Hi Ron, I've implemented a system of leveraging the audit form capability to capture individual field edits to a central audit form at a couple of sites.
With form auditing on, each time a new row is written to the forms respective audit form the fields that have changed are stored in one field. I parse that field and extract the old and new values for each field (from previous central audit records and from the new audit form) and put them in to a single form. This allows detailed reporting on who changed what field from what and when. Yes, it does chew up a bit of disk space but remember 1) disk space is relatively cheap these days 2) you don't need to audit every field 3) you can archive the audit data. I recommend taking this project on. Remedy has some very neat auditing and archiving features that you can use to their potential. Good luck, Rod On 6 December 2013 06:45, Ron Young <rpyo...@southernco.com> wrote: > User 7.6...Developer 8.1. I have been asked to capture in the transaction > diary any time anyone touches any field. I know how to do it for individual > fields but I don't know how to just make a blanket statement saying this > field was changed by A on 12.5.13 and then that field changed by B on > 12.5.13 if you get my point. Let me know if there is a way. > > Thanks, > Ron Young > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
