I am not finding a similar topic, or the answer I need.
I have about 20 fields that will be populated, then reviewed periodically. Each time they are reviewed, the values have the potential to be changed. If they are changed, someone else needs to review the changes. They do not need to review all of the other fields for a record.
I thus need an easy way to call out the changed fields:
If field “a” changed, show a big UPDATE! notification in field “a-update.”
Previously, I’ve built out 20 formula fields to do this, but that required having field “a original,” field “a new” and then field “a-update (formula)” which was IF(“a original”!=“a new”, UPDATE!). The new table isn’t set up this way- we’re not always going to show the old version AND I really really don’t want to keep building out 20 formulas.
What I’d love to do is an automation that populates field “a-update” with UPDATE!, and I’d like to do one automation that covers all of my fields. Is this possible?
If necessary, I can build a formula field that would show changes, but I’m not sure quite how to do that without displaying the original value.
Airtable will be coming out with conditional logic for Automations pretty soon. That should allow you to nest as many IF statements as you need and set one for each of the fields within the same Automation.
I’d recommend waiting until that beta comes out and then playing with the options before diving too deep into an alternative.