Discussions

Expand all | Collapse all

How to convert a set of Text fields to an Address field

  • 1.  How to convert a set of Text fields to an Address field

    Posted 21 days ago
    Greetings,

    I have a linked table that pulls in CSV data from another system. Included in the data set are 5 text fields that define an address: Address1, Address2, City, State, and PostalCode. I'm wondering how I could go about converting those into a field of type Address either in the linked table or in another table.

    I'm dreaming of a Formula-Address field which would support concatenating the 5 fields referenced above -- but alas no such formula field exists. Is there another way?

    Thanks in advance.

    ------------------------------
    Rick Putnam
    ------------------------------


  • 2.  RE: How to convert a set of Text fields to an Address field

    Posted 21 days ago
    I would setup an Address field in the same table where the data is pulled from the other system. Then, create an Automation that runs when a new record is created and have it move the information from your CSV fields into the various parts of the Address field.

    ------------------------------
    Blake Harrison - DataBlender.io
    Quick Base Solution Provider
    ------------------------------



  • 3.  RE: How to convert a set of Text fields to an Address field

    Posted 20 days ago
    That makes sense, Blake. Thanks for the suggestion.

    ------------------------------
    Rick Putnam
    ------------------------------