I have a table to prepare a quotation having the following columns - [Unit Price], [Discount], [Qty] & [Total]. The column [Total] has an app formula. An action button ‘Approve Quote’ sets the value of [IsApproved] to TRUE and is visible only to managers.
I want that each time the columns in the row is modified or the [Total] changes, the row needs to be approved by the manager through the action button. I have a column TrackChanges that monitors the required columns and set the TrackChanges to Reset.
I have set the initial value of IsApproved to FALSE and enabled Reset on edit. The expression for Reset_on_edit is - [TrackChanges]>0
However, when I edit certain columns and save the row, the [TrackChanges] increments but the [IsApproved] does not reset to initial value. Kindly help me resolve this.