Is it possible to reverse the updated field automatically when record is deleted?

For example, If we create a sales order and entered the quantity that updates the stock level to decrease the value in another sheet and then deleted the sales order or edit it, the updated field of stock level should reverse the previous update to increase back the value.

I think it is logical that this feature is exit otherwise values won’t be accurate in the database. This is normal that users forget to update manually every time they delete or edit a record that has linked field to other sheets.


Currently, there is no any script that related to deleting so it might still have to manually check.
We do have forward this to our development team to see if we could support the scripts.