How do you use snapshot on fields from the same table?

Question

I'm trying to manage hundreds of dates.  The reason for snapshot is so that if the one date gets changes, I'll still have record of the original date no matter how many times its been changed.  Unfortunately, you can't pull lookup field from the same table.  So instead, I have tried to create relationship of the table with itself so I can have that lookup field but that didn't work out.  What I want is the first time Construction Date is filled, so does the Original Construction Date.  When Construction Date got pushed down, even a few times, the Original Construction Date will stay the same.  Can anyone help me out?

QuickBaseCoachD · Answer

Well, in fact you can relate a table to itself and pull snapshot field. Make a formula numeric field called [Record ID# mirror] with formula of [Record ID#] and make your reference field on the right side of the relationship that field. Pull down [Construction Date lookup] as a lookup and then make a field called [Original Construction Date] as a snapshot of [Construction Date Lookup].

Be sure that Construction date is a required field or else it will snapshot a blank Construction date.

Sign up

Login to the community