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.
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Yes, you would create an audit trail child table and record the old and new values.  if there are multiple fields to track, then include in the child table and identifier of the field that was changed.  Like Cost or Sell.

Using an ACTION will allow you to record the old and the new value.  Automations don't yet do the "old" value,.