I’d like to be able to create fields that cache data the moment its condition is met. The cached data should be continuously displayed until additional, optional conditions are met.
For example, another user was trying to cache dates when a checkbox was toggled. Could they just use a ‘date modified’ field? Sure - but that’s fairly limiting. What if users want to log a timestamp when a given single select is selected?
How it might look
Status (single select)
Kickoff
Working
Revised
Completed
Last Revised (conditional store)
Store Condition:
If Status is “Revised,” store the current time.
Update Condition:
If Status was something else, and now it is “Revised” again, store the current time.
Revision Counter (conditional store)
Store Condition:
If Last Revised has a value, then store the value 1.
Update Condition:
If Last Revised has been modified, then +1 to the stored value.
