Discussions

Expand all | Collapse all

Pull up previous field data

  • 1.  Pull up previous field data

     
    Posted 30 days ago
    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
    ------------------------------


  • 2.  RE: Pull up previous field data

    Posted 30 days 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
    ------------------------------