Forum Discussion
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__You
Qrew Legend
6 years agoWhile 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
------------------------------
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
------------------------------- GeorgeBramhall26 years agoQrew CadetI have done that (added the 6 lookup fields from the parent). The child table has been actively using the address field to capture the six subfield information. As you suggested above, I should be able to access the subfields and click the snapshot functionality, but I don't see how I access those subfields to do so.
------------------------------
George Bramhall
------------------------------
- MarkShnier__You6 years ago
Qrew Legend
I just did a test and looked up the field Address Street 1 from a parent to a child. Then on the child record I made a new text field and then went into field properties way down at the bottom and set it to be a snapshot of the Parent- Address Street 1 lookup field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- GeorgeBramhall26 years agoQrew CadetYes, I understand that you can create a new field in the child table, but I already have many records that are using the existing Address field. I don't want to create another field for the City, State, etc. It already exists. I was just hoping that I could go directly in to each subfield and turn on the SnapShot functionality.
------------------------------
George Bramhall
------------------------------