Discussions

Expand all | Collapse all

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

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

    Posted 05-23-2017 16:36
    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.


  • 2.  RE: Capture value of field from related table, but only at that moment

    Posted 05-23-2017 16:52
    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.  


  • 3.  RE: Capture value of field from related table, but only at that moment

    Posted 05-23-2017 18:21
    Ahhh I must have missed that snapshot option.