Tracking history without logging
I have a text field that I want to keep one "previous" value for, in a separate field (not logging). This text field has an automation that updates it when a field in a connected table in QB Onlin...
Forum Discussion
If I've understood you properly, you have two fields [Current Value] and [Previous Value]. When [Current Value] updates, regardless of how, [Previous Value] should be set the the old value of [Current Value]. A second Automation can set your [Previous Value] field to be the Old_Value of your [Current Value]. The second Automation should fire only when [Current Value] is modified, but it will fire in response to any change, whether it comes from a user or another Automation, (or an API call, or whatever else might change it).
------------------------------
Ben Smith
------------------------------
------------------------------
Ben Smith
------------------------------
For the second Automation, I don't see how to write the Action portion.
In the Trigger, I can say "If the record changes, and the Current-Acct field is updated...."
But then in the Modify Action, it doesn't automatically stay in the same record, it wants to modify a related record.
I can choose the same table using the "advanced" feature, but
- I don't see how to go to only the record that was just updated (I don't want to update all of them!)
- I don't see any way to choose the "previous value" in the action portion, like you can when you are modifying a related record.
What am I missing?
------Original Message------
If I've understood you properly, you have two fields [Current Value] and [Previous Value]. When [Current Value] updates, regardless of how, [Previous Value] should be set the the old value of [Current Value]. A second Automation can set your [Previous Value] field to be the Old_Value of your [Current Value]. The second Automation should fire only when [Current Value] is modified, but it will fire in response to any change, whether it comes from a user or another Automation, (or an API call, or whatever else might change it).
------------------------------
Ben Smith
------------------------------
