Zapier integration: How to get separate name and address fields?

  • Jan
    Asked on February 18, 2021 at 8:36 AM

    Hello,

    I have a question about Jotform integration - when someone enters their address, Jotform puts all fields into just one line in the API response. I can split it by commas, that is fine (as long as someone doesn't use the comma in any of those fields), but it is causing issues with the 2nd address line (which is optional). By leaving out one of the lines, the field order changes and so will the data that I am sending further.

    Similar with names - in the form itself, it is as 2 fields. But in the API response, it is just one field separated by a space. What if someone adds the middle name?

    Thank you for your help,

    Jan

  • Sam_G
    Replied on February 18, 2021 at 9:42 AM

    Hi Jan,

    I'm afraid the 'Full Name' field will be always considered as a single field when passed into other fields.

    Please do not delete the existing Full Name field since this will also erase submitted data for this field. If you decide to separate fields, please hide the Full Name to save the data. 

    You might also want to check the Split Text option, though I'm not sure exactly if that is what you need. Here's the link: https://zapier.com/help/formatter/#using-split-text.

    As a workaround, you can use separate short text entry for each sub-field. 

    For example: 

    - Short text entry for Name.

    - Short text entry for Middle Name.

    - Short text entry for the Last Name.

    Let us know if this meets your requirements.

  • Jan
    Replied on February 18, 2021 at 10:00 AM
    Hey Sam,
    Thank you. I understand this option - but for the address, I would have 5
    separate steps instead of having just one with 5 fields (2 address lines,
    city, state and the post code).
    Is there anything else that I am not seeing?
    Thanks,
    Jan
    ...
  • Sam_G
    Replied on February 18, 2021 at 11:23 AM

    Hi Jan,

    It can be separated, this code will help you to get the value of each field: 

    {address:addr_line1}

    {address:addr_line2}

    {address:city}

    {address:state}

    {address:postal}

    {address:country}

    You will need to replace the "address" with the name of your field, this guide will help you to get the name: How-to-find-field-IDs-and-names

    You may display each field on the Thank You Page, Email Notifications, or send it through URL to another form or page.

  • socialtenacity
    Replied on February 18, 2021 at 4:03 PM

    Hey Sam,


    Thank you, but I don't really see it there. Just the unique name, not IDs.

    https://prnt.sc/100691z

    I don't really want to display it on the Thank you page or anywhere else, I really just want to split this information for the API - to be individual records instead of one long string.

    I found this article and it is not really what I am looking for:

    https://www.jotform.com/help/351-how-to-automatically-pass-form-data-to-another-form


  • Zahra_S
    Replied on February 18, 2021 at 9:35 PM

    Hello Jan,

    I see that you are using Card Form and field IDs are not available in that form layout.

    The ideal workaround to pass separate field data to Zapier is by adding separate short text entry fields for each value. Please note that you can add one field per card in the Card Layout. You will have to ask the user to ask for first name and last name on separate cards. If this doesn't work for you, you can change the form layout to Classic.

    I hope this helps. Please let us know if you need further assistance.

  • socialtenacity
    Replied on February 19, 2021 at 10:05 AM

    Hi Zahra,


    thank you, but for address, I would have 5 cards, that is quite lot. But I was recommended using the Form Calculation widget with Multi-line question.

    As the outcome is separated by commas even when the field is empty.

    I will give it a try and see if that works.

    Thanks,


    Jan