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?

  • Profile Image
    bigwilliestyle
    Asked on October 02, 2016 at 05: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)

  • Profile Image
    jonathan
    Answered on October 02, 2016 at 06: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.