Skip to main content
Question

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

  • May 23, 2017
  • 0 replies
  • 39 views
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.
      This topic has been closed for replies.

      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.  
      Ahhh I must have missed that snapshot option.
      Terms & ConditionsAccessibility statement