Forum Discussion

MichaelTamoush's avatar
Qrew Captain
4 years ago

Copy an address

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

7 Replies

  • 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
    • AlexCouts1's avatar
      Qrew Trainee

      do you have an example of this formula in a forum post else where? 

      Alex Couts
      • MarkShnier__You's avatar
        Icon for Qrew Legend rankQrew Legend

        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)