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.
ETA: I think this user is sort of describing what I’m looking for, but I do have the added field of the user checking off that they’ve reviewed the record. They’re just not noting when they’ve updated a field. FR: Show Revisions to Specific Fields Only -OR- Tied to Shown Fields in View