AnsweredAssumed Answered

CREATING AN AUDIT/MODIFICATION LOG

Question asked by RACHAELRIGG on Jun 26, 2013
Latest reply on Jan 20, 2014 by ngarnier

Title

CREATING AN AUDIT/MODIFICATION LOG

Post

      

     Hi there
      
     I've been trawling through forums trying to find a way to write a script that captures changes to fields as they are committed, capturing the following components:
     - timestame
     - account name of the active user
     - the field name of the modified field
     - its original value before the modification and
     - the new value
      
     Currently i can only get the first two auto-enter values to log in the database. Really need to capture "last visited record" and it's contents. 
      
     I've also tried to run the script with a related table in the same file AND related table in a separate database (thinking the latter may be less messy) but i've had limited success. 
      
     Any help would be SO appreciated.
      
     Thank you so much for your time.
      
     Rachael

Outcomes