I have a data collection AppSheet application used for an inventory project.
I have created a QA view so that a manager can do a quality check on a % of the inventoried assets.
During the QA process, the manager can make changes to any of the fields to correct any inaccuracies entered by the inventory technicians.
I have added a field called “Changes Made During QA” that is a Y/N field to record when there was a change made during QA.
Because the QA manager may go into the Form view (editable) without making any changes, and they can save the data with no changes, I cannot assume that visiting the Form view means that the “Changes Made During QA” field should be set to Yes.
Is there a way to set up an event that gets triggered ONLY if the data in the record is changed? FYI - Also need to check if related records in another table have changed.