Forum Discussion

CharlotteMorin's avatar
CharlotteMorin
Qrew Cadet
5 years ago

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...
History
Quickbase Automations
BenSmith's avatar
BenSmith
Qrew Member
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
------------------------------
CharlotteMorin's avatar
CharlotteMorin
Qrew Cadet
5 years ago

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
------------------------------