Need address fields on different lines on Zapier

  • Profile Image
    euterpastudios
    Asked on February 03, 2021 at 10:03 AM

    Hi,

    I spent a lot of time with autocomplete widget by setting it up via the google map API,
    I get the address correctly formated in the form.

    But when the form pastes the data via zappier to my CRM, Close.io (that will later paste it to Zoho invoice), it pastes everything in only one line and have also the wrong country...

    I've contacted the CRM support but they say it's related to jotform, cause their zap has the necessary input fields, it's jotform that don't seems to provide the outputs.
    Please see included pics.

    1612364424_601aba88892d3_2.png1612364422_601aba86df9ee_zap.png1612364422_601aba868b0fc_1.png


  • Profile Image
    Gaetan_B
    Answered on February 03, 2021 at 12:47 PM

    Hello,

    Thank you for reaching out.


    The address field doesn't separate the different parts of the address.

    To send data over the way you would like, you would have to make each field separated by using the Short Text property for instance:

    1612374435_601ae1a39152d_


    Hope this helps.

    Do not hesitate to reach out if you need further assistance

  • Profile Image
    Nelson 
    Answered on February 11, 2021 at 04:32 AM

    Well I know this! This is why I create this ticket in the first place.

    When I receive the jotform copy in my inbox the fields are correctly separated so I assume the output it's somehow reflecting the input. They just disappear in the Zap.

    So please fix the Zap to have it sends the different fields.

    Using short text = augmenting bouncing rate, so that's not a solution at all. We are here to simplify the things for the visitor in order to turn him into a potential customer...

    First I get rid of the fancy card form I order to implement the auto complete widget that took me sometime because of the Google api connection needed, now the form is quite ordinary except for this awesome autocomplete feature. If there is no solution to use it correctly I don't need to spend so much on not jotorm monthly, I will have to use a basic free contact form and cancel my monthly subscription.

    So please fix this issue, because it is an issue.

  • Profile Image
    Sam_G
    Answered on February 11, 2021 at 04:37 AM

    Hi Nelson,

    We're sorry for the inconvenience.

    Please note that the address field is one single field and it is not possible to read it separately in Zapier integration. I would suggest you please use a separate short text entry field in the 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. 

  • Profile Image
    euterpastudios
    Answered on February 11, 2021 at 05:25 AM

    And if I send the data from jotform to a Google spreadsheet (then later to my CRM) while the full address still be on only one line?

  • Profile Image
    ashwin_d
    Answered on February 11, 2021 at 05:45 AM

    Please note that the address field is a collection of multiple fields, but it is still one single question. When you integrate form with Google Spreadsheet, the address data will be sent to separate columns.

    If you can connect to Google Spreadsheet to read the submission data and send it to your own CRM, the address fields data can be assessed separately as they will be in separate columns of integrated Google Spreadsheet.

    Hope this helps.

    Do get back to us if you have any questions.