Forum Discussion

ConnieBroadie's avatar
ConnieBroadie
Qrew Trainee
5 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
Qrew Champion
help me understand this.

I set up an automation for 25 fields. Trigger is when that specific field is modified, with action to add a record to NCR Audit Log.

Do you have 25 Automations? If so, why can you not just add a field to the Audit log called [Field] and have the Automation write the field name into that field?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
ConnieBroadie's avatar
ConnieBroadie
Qrew Trainee
5 years ago
I think the light bulb just went off. I got it. Thanks!

------------------------------
Connie Broadie
------------------------------