Discussions

Expand all | Collapse all

Extract part of address from address field

  • 1.  Extract part of address from address field

    Posted 11-15-2018 17:36
    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>





  • 2.  RE: Extract part of address from address field

    Posted 11-15-2018 17:43
    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.


  • 3.  RE: Extract part of address from address field

    Posted 11-15-2018 18:36
    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? 


  • 4.  RE: Extract part of address from address field

    Posted 11-15-2018 18:38
    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.


  • 5.  RE: Extract part of address from address field

    Posted 26 days ago
    Hi

    Quick question, do you know if it's possible to make an address field have a default value? For Example Address field A will always have the address 1234 Street 1 City State Zip Code.

    ------------------------------
    Wallace (DHS) Yeboah
    ------------------------------



  • 6.  RE: Extract part of address from address field

    Posted 26 days ago
    I suggest building a quick little automation.
    When a record is added and the address field is blank, say address line one is blank, then have the automation fill in all the address field components.


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



  • 7.  RE: Extract part of address from address field

    Posted 26 days ago
    Perfect! Thanks alot Mark.

    ------------------------------
    Wallace (DHS) Yeboah
    ------------------------------