I'm using the Zapier integration to store form submissions in Google sheets. Is it possible to separate out the address fields into separate columns?

  • bigwilliestyle
    Asked on October 2, 2016 at 5:39 PM

    Right now the address field is stored in a single column, and I was hoping that it would be possible to create different columns for (address 1, address 2, city, state, zip)

  • jonathan
    Replied on October 2, 2016 at 6:21 PM

    Unfortunately you cannot. The combo Full Address field when transported to spreadsheet integration will always be considered as a single element or field. This was the reason it will only appear as a single(1) column in the spreadsheet.

    A workaround you can do is to use separate Textboxes fields for each element of the Full Address field into your form.

    Example:

    Address 1

    Address 2

    City

    State

    Zip

    --

    Hope this help. Let us know if you need further assistance.

    Thanks.