Logging edit history for Numeric Field
I want to log the edit history for a Numeric field. I tried creating FORMULA-TEXT field. But using that i can log only last edit details. But i want to log all the edit history for that Numeric Field....
Forum Discussion
There isn't necessarily a field setting that can log number changes - but you can use Automations as a pseudo-log - and whenever your number changes, there is a built in way with automations to track the 'old' value and you can write that old value into a different field. Just pop that new field as an admin only field and you're all set.
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
With an automation there are two values you can grab - the current value - meaning what the value is right now, and the 'old' value, which is the prior value.
So if your number changed from 100 to 200 - an automation knows how to pull them both and you can log either.
As for tracking the entire history - you would still need a text field with logging turned on. Basically you would use an automation to push the value you want to preserve into a text-log field so you have the running history. Its basically the same method as a using a standard text field with logging - you just need the automation to populate it
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
So if your number changed from 100 to 200 - an automation knows how to pull them both and you can log either.
As for tracking the entire history - you would still need a text field with logging turned on. Basically you would use an automation to push the value you want to preserve into a text-log field so you have the running history. Its basically the same method as a using a standard text field with logging - you just need the automation to populate it
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base