Skip to main content
Question

Pull up previous field data

  • October 30, 2020
  • 0 replies
  • 77 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • October 30, 2020
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement