How to separate the address field data in Zapier?

  • nwongrat
    Asked on August 11, 2020 at 9:39 AM

    1. How can I sync the data using zapier and be able to separate the name and address field?? Right now when I sync data from jotform to google sheet especially address field. All of information such as address city state, they  go as one field but when I export as csv, it could separate the field.


    2. Is there any way to have other user viewing the submission? Do you have this in gold plan?
  • Ashwin JotForm Support
    Replied on August 11, 2020 at 10:42 AM

    #1. Are you trying to use Zapier to integrate to Excel sheet? Please note that address field is one single field and it is not possible to read it separately in Zapier integration. I would suggest you to please use separate short text entry field in form for street 1, street 2, city, state and zip code and then you will be able to send the data to separate fields.

    Hope this helps.

    Do get back to us if you have any questions. 

  • Ashwin JotForm Support
    Replied on August 11, 2020 at 10:43 AM

    I have moved your second question to a new thread so that we can address it separately. You will be answered in the following thread: https://www.jotform.com/answers/2504963