Recording the date a form was last Saved:
I currently have a field, [LastVerification] using ‘TODAY()’ as an app formula. When the row is initially created and then saved, this formula records the current date. If this row is saved again in the future, the then current date over-writes the previous date. Seems to work as expected.
I also have a DateTime field, [ManualReport]. This field is part of an action that allows the user to email themselves a PDF report of the data. When the user clicks the action button the current date & time is recorded.
It seems that action buttons cause all formulas within the ROW to be run which causes the [LastVerification] field to be updated which is not the desired action.
What might be the best method to record ONLY when a ROW is first created or updated via manual means but not when an action is run against a single field in the row?