HELP Saving field information using script triggers
I am trying to figure out a way to save field information in another field using a script. We currently have no way to track when somebody changes information. What I was wondering is if there is a way to use the layout Script Trigger OnRecordCommit to grab the information was was just modified and the new information and save them into another field so I can generate a report from this.
If the layout trigger doesn't work, is there an object trigger that will do it?
Google FM Audit trails, there are many techniques.
However, when faced with this requirement, I do a popup edit window. On popup, I capture original values into $vars. Then, on Done, I run a script that compares the $vars to the field values and if they have changed, I write an audit record.