Time stamp for Record modification
Is there a way to record a time stamp in a notes field for any time a record is modified? For example, a time stamp and user is recorded when a user changes the phone number of a customer or add a dea...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIt sounds like you are trying to create an Audit trail of who changed what, when.
i suggest setting up child table with fields for the user and the old value, the new value and the field name which was changed.
Then set up an Automation to trigger when the record is modified and field one changed. The action step will be to write out a child Record. You will be able to fill the user field with Last Modified by and it will also let you out the old value into a field in the audit Log Table.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
i suggest setting up child table with fields for the user and the old value, the new value and the field name which was changed.
Then set up an Automation to trigger when the record is modified and field one changed. The action step will be to write out a child Record. You will be able to fill the user field with Last Modified by and it will also let you out the old value into a field in the audit Log Table.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------