Forum Discussion

JenniferJennif1's avatar
JenniferJennif1
Qrew Trainee
8 years ago

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

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.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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.