Forum Discussion

GraniteHomes's avatar
GraniteHomes
Qrew Cadet
5 years ago

Snapshot Field From Same Table

Looking for a way to create a snapshot field on a field in the same table.

Example:  I add a sale and a field generates a fee (using a formula field).  This fee may change if the total sale amount changes.  But if I make a change to the fees formula, I want the old value to stay.

So update the snapshot field if the sale price changes but keep it the same if the formula values are changed.

------------------------------
GH GH
------------------------------

1 Reply

  • You could relate the table to itself based on Record ID# and then do the lookup and then a regular snapshot.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------