Forum Discussion

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

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.

DavidBrogdon

Qrew Assistant Captain

7 years ago

Would I just create a record in a different table every time the value changed in the source table/record?

Forum Discussion

Need to track and calculate a changing numeric field

Related Content

IF statement changing numeric to text

Calculating 1.5 pay

Calculation/Performance Limits Inquiry

Calculating number of days between two date fields

Trying to calculate On Time delivery