Forum Discussion

RickPutnam's avatar
RickPutnam
Qrew Cadet
4 years ago

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

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 ...
Tables and fields
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
4 years 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
------------------------------
  • RickPutnam's avatar
    RickPutnam
    Qrew Cadet
    4 years ago
    That makes sense, Blake. Thanks for the suggestion.

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