Forum Discussion

UrsulaLlaveria's avatar
UrsulaLlaveria
Qrew Assistant Captain
5 years ago

Pull up previous field data

I know there is a way to do this, but I am completely blanking. How can I get the previous status of a field? For example, I have a Status field that has Active, Inactive, Deleted. I want to see what the previous status was of a record. Is there a formula to pull this in? Something like: old.fieldID? 
I know you can get it in an automation, so I am assuming there is a formulaic way of doing this too.

------------------------------
Ursula
------------------------------
Quickbase Automations
Tables and fields
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    No, the "old." value only exists for a split second while a Notification or an Automation is firing.  After that it's gone.  In a Notification, you can use the Syntax 

    [old.Status]

     to get at the previous status just long enough to fire off the Notification.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------