Forum Discussion
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
------------------------------
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
5 years agoQrew Trainee
Yes, I have 25 different automations, one for each field we need logged. I didn't know I could do that... So how would I do that? I don't want the info that is in the field, I want the field name. Would it be a formula field? It is probably a super simple thing, but the lightbulb is not going off.
------------------------------
Connie Broadie
------------------------------
------------------------------
Connie Broadie
------------------------------
- MarkShnier__You5 years agoQrew ChampionI think that you are overthinking this.
Create a target field in your Audit Trail called Field Name.
Then edit each of the 25 Automations to to populate that field with words. It's just another field just like old value new value etc, just another field. When you go looking for a "Source" for the data an option will be Type a value, so you Type a value like Qty or Price
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- ConnieBroadie5 years agoQrew TraineeThank you! Yes, I was definitely overthinking it. I appreciate your assistance!!
------------------------------
Connie Broadie
------------------------------