Copy an address

Question

If I have a lookup field that is an address, can I use a button to copy that field to another address field?

Or do I need to look up each component (street, city, state, zip, etc) and then copy each component to each corresponding component?

------------------------------
Mike Tamoush
------------------------------

markshnier__you · Answer

You need to populate the 6 subfields individually so you need to lookup the 6 fields as well as the combined [Address] field. Then use & "&_fid_101 =" & URLEncode( [Address: Street 1 ]) etc in your URL button.

There is no shortcut.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

alexcouts1 · Answer

do you have an example of this formula in a forum post else where?&nbsp;------------------------------Alex Couts------------------------------

markshnier__you · Answer

If you have a situation where you have a look up field for an address field and want to populate a native address field on a child record, I suggest making a checkbox which will trigger form rules to copy the address components of the look up field into the individual fields. You will need to have. Lookup fields on your relationship for the six individual components of the address field.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

markshnier__you · Answer

if you use the checkbox method, then the user will need to edit the record and check the checkbox. Or perhaps they are already in Add mode on the record, and they can check the checkbox and Add mode.

if your workflow is such that you really do want a URL formula button, which would only operate in View mode then post back and I can help you with that.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

alexcouts1 · Answer

so no child records in this situation. this would be on the same record. ie: one record has a Mailing Address field and a Billing Address field, i want the user to be able to fill out the mailing address and then hit a check box that says "mailing address same as billing address" that will lock out / hide the billing address field while the user is still editing the record, and then when the record is saved, populate the billing address fields with the information from the mailing address fields.&nbsp;
------------------------------Alex Couts------------------------------

Forum Discussion

Copy an address