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
QuickBaseJunkie
Qrew Legend
Qrew LegendHi Desiree!
A simple way that I've done this in the past is to create a formula field with the pertinent fields such as:
Then set up a form rule that changes a multiline text field (where log edits is turned on) to the values in the formula field. This will create a log of all the field values each time the record is saved along with the names and dates of who set those values. You could easily trace back who changed what in that field.
Note that this will only work if edits are being made with the form and not through mass edit actions (like grid edit or automations).
Let me know if this is helpful 😀👍
–Sharon
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
A simple way that I've done this in the past is to create a formula field with the pertinent fields such as:
"Account Name: " & [Account Name] & "; " &
"Account Number: " & [Account #] & "; " &
"Contact Name: " & [Account Contact Name] & "; " &
"Activity Type: " & [Activity Type] & "; " &
"Status: " & [Status]
Then set up a form rule that changes a multiline text field (where log edits is turned on) to the values in the formula field. This will create a log of all the field values each time the record is saved along with the names and dates of who set those values. You could easily trace back who changed what in that field.
Note that this will only work if edits are being made with the form and not through mass edit actions (like grid edit or automations).
Let me know if this is helpful 😀👍
–Sharon
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------