Audit Log - Add field that identifies which field changed

Question

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 Value field, Date Last Modified and Editor (person making change). My issue is I can't figure out how to identify and include the name of the field (field label) being changed in the Audit Log form. I am grateful for any suggestions!

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

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community