Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoAre you aware of the native snapshot function? https://help.quickbase.com/user-assistance/setting_up_snapshot_fields.html If you make a snapshot field, the you would know what the value was at the time the child record was created and also what the current lookup value is.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
GeorgeBramhall2
6 years agoQrew Cadet
Thanks the Snapshot solution will work for me for most field types. I would like to know how to handle address field types as mentioned above.
------------------------------
George Bramhall
------------------------------
------------------------------
George Bramhall
------------------------------
- MarkShnier__You6 years ago
Qrew Legend
While we do not seem to be able to snapshot a whole address field, I believe that you can lookup the six individual address components such as
Address Street 1
Address Street 2 etc and then snapshot them individually.
Then if you need to reassemble them to look like an address block you can mess around with a formula like this one.
List("\n",
[Address: Street 1],
[Address: Street 2],
List(", ", [Address: City], [Address: State/Region]),
if(trim([Address: Street 1])<>"",[Address: Country]),
[Address: Postal Code])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- GeorgeBramhall26 years agoQrew CadetI searched the fields in the child table and only see the Address field but not the sub-fields. Where do I access these 6 sub-fields to select the Snapshot option?
------------------------------
George Bramhall
------------------------------- MarkShnier__You6 years ago
Qrew Legend
:) you need to create 6 lookup fields from the parent.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------