We have a base with many tables with “sections” of fields that need to be reviewed by a second pair of eyes. Sometimes records will have 3 or 4 of these “sections,” and a person doing the entry might work on 2 of them at once.
I want to have automations for each of the sections that:
- Changes the status in a “review status” field from “Reviewed” to “Re-Review,” and
- Clears the “reviewed” date,
This lets us know that we need to re-review those fields. This same record, in the same table ALSO needs this automation, and a third:
Is there a way to combine these into one automation? The conditional action doesn’t seem to do it, and I can’t seem to figure it out with views.
I do not want to merge the “needs review” fields for the specific sections into one mega-“needs review” because only specific fields need review.