Capture value of field from related table, but only at that moment

  • 1
  • 2
  • Question
  • Updated 1 year ago
  • Answered
I have a parent table called Requests with a field called Status. I have a related table called Log with a field called Log Status.

At the time I create a new record in Log I want to capture the current status of the request. I've tried Lookup and formulas but the Log Status field keeps changing on already created records whenever the Requests Status field changes.

Basically I'm creating log entries and want to record the state of the request at that time but not change it dynamically in all Log entries every time the Request Status changes.
Photo of Jennifer

Jennifer

  • 182 Points 100 badge 2x thumb

Posted 1 year ago

  • 1
  • 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
No Problem.  Quick Base anticipated your need.  You already have a lookup field called [Status].  For clarity, rename it to be called [Status (lookup)] .

The create a new text field called [Status (snapshot)].  Way down at the bottom of the form properties you can specify it to get its value for that lookup field and freeze it.  (ie take a frozen snapshot of it at the time the lookup was  first populated.  
Photo of Jennifer

Jennifer

  • 182 Points 100 badge 2x thumb
Ahhh I must have missed that snapshot option.