Forum Discussion

ConnieBroadie's avatar
ConnieBroadie
Qrew Trainee
6 years ago

Audit Log - Add field that identifies which field changed

I have a table (Audit Log) that logs changes made in another table. They are related. I have an automation set up for each field I want to track changes in. The Audit Log form has Old Value field, New...
Audit
Quickbase Automations
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Since you have say 5 Automation for the 5 fields being audit logs, you can actually just have a mapping in the Automation to actually write text, like any phrase, into a field, so use the option called "Type a Value"  if the target field is a free form text field or else probably better, make that target field a multiple choice field.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------