Skip to main content
Question

Concatenate text fields to create an address

  • June 20, 2018
  • 0 replies
  • 149 views
I have a spreadsheet that I plan to upload to QB that has text fields for:

Address Street Info (Text Field)
City (Text)
State (Text Abbrev)
Zip (Text)


If I create a text formula that concatenates these strings together, will QB recognize this as an address?
    This topic has been closed for replies.

    Forum|alt.badge.img+17
    • EvanMartinez
    • Community Moderator
    • June 20, 2018
    Hi Ashely,

    So long as the table you are importing into contains an Address field upon import you can target the individual sub fields that make up an address. So your Street info would go into the Quick Base Street Info sub field and the same would match up for City, State, and Zip. Quick Base creates one address field that is made up of a sub field for each. Where as it would not be able to recognize a concatenated string, it is better to import in each field to the correct address sub field. 
    Terms & ConditionsAccessibility statement