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
------------------------------
- GeorgeBramhall26 years agoQrew CadetI notice that the Snapshot functionality is not available for certain field types, e.g. Address. Any idea how to get Street Address in the Parent in to the sub-field Address: Street Name in the child?
------------------------------
George Bramhall
------------------------------- Laura_Thacker6 years agoQrew CaptainUse a form rule, if the record is being opened and actively saved; or an automation of some kind to fire when the record is created.
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
- GeorgeBramhall26 years agoQrew CadetThanks 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
------------------------------- 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
------------------------------