Forum Discussion

DavidBrogdon's avatar
DavidBrogdon
Qrew Assistant Captain
7 years ago

Need to track and calculate a changing numeric field

My boss has informed me that from an auditing standpoint, users should not be allowed to change the original order quantity field, but instead we should design a system that logs each numeric change (...
APIs and custom code
Forms
Formulas and functions
SuryaExpert's avatar
SuryaExpert
Qrew Assistant Captain
7 years ago
Can be done with a webhook or automation. If you need to record the old value and the new value of the order quantity field, use a webhook as you can access the old value as well as the new value in a webhook.
SuryaExpert's avatar
SuryaExpert
Qrew Assistant Captain
7 years ago
Yes. Create another table and make sure the webhook adds a new row in that table whenever this field changes. Technically speaking, you could extend this to other fields on the orders table as well. It is your call, though.