Reputation: 13
How would you do to implement Audit Trail eg. add User Action(edit, new, delete, print), OldValue and NewValue in a separate "Audit Trail" table? Something like this:
ID | DATE | USERNAME | FORMNAME | ACTION | FIELDNAME | OLDVALUE | NEWVALUE
01 180513 user form1 edit Risk Low High
Old values must not be overwritten and I am kind of a stuck there because "patch" overwrites old values...
Upvotes: 0
Views: 1441
Reputation: 4415
One option may be to confirm each change.
Example:
OnSelect
Property of the "Confirm" button to write a new line to the Collection/Data SourceDefaults
line in your Patch
command to APPEND this line to the Collection/Data Source each time rather than overwriting it. Good luck!
Upvotes: 1