Forum Discussion
QuickBaseCoachD
Qrew Captain
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.
Be sure that Construction date is a required field or else it will snapshot a blank Construction date.
GianniGiacchi
6 years agoQrew Trainee
I am in the situation where the date field i need to snapshot is not and cannot be required because it usually gets populated a few weeks after the record is made. However, I do not want a blank snapshot. I want a snapshot of that date field when it is first changed/populated with a non-zero date.
Is this possible to achieve?
Is this possible to achieve?