Skip to main content
Question

Extract part of address from address field

  • November 15, 2018
  • 0 replies
  • 201 views
Can I extract data from an address field so that I can format the address when printing it on a letter?


Example


Address field: 

3300 North Brook Place, Boise, ID 83710 United States



How I want to format address:

<p>3300 North Brook Place</p><p>Boise, ID 83710 United States</p>



    This topic has been closed for replies.

    If you look at the address field properties, you will see that it is really made up of 6 fields, and each has its own field name and Field ID#, so "yes" is the answer to your question.

    Post back if you need help with the actual formula.
    • AndreaPahor
    • Author
    • Quickbase Alumni
    • November 15, 2018
    Thanks. 

    I found the address fields you described. But I have encountered a new problem. 

    The address I want to format (a customer contact address) is in the "Proposals" table.

    The address in the Proposals table is a lookup to the "Customer Contacts" table. 

    The address in the "Customer Contacts" table is a lookup to the "Site List" table. 


    What is the best way to do this? Should I format the address in the "Site List" table then carry the formatted text through to the "Proposals" table as a lookup? 
    Yes, I suggest that you do this on the highest up source record, so that it is easily available as a lookup field anywhere else in the app, or else you will find yourself re-building that formula concatenation field over and over, on each child and grandchild table.
    Terms & ConditionsAccessibility statement