Skip to main content
Question

Need to track and calculate a changing numeric field

  • December 6, 2018
  • 0 replies
  • 97 views

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 (for example -5 or +9), while also using each value in a transaction log so that the final total (whether + or -) can be added to the original value in order to get the true value. 

Any ideas on simple yet effective ways to implement this? 

Thanks for any help. 
This topic has been closed for replies.

  • Registered
  • December 6, 2018
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.