Separating Address field data

  • stevenkessler
    Asked on August 5, 2016 at 1:13 PM

    Can it capture separate fields for street, city, state, and zip when using the Address field?  Or do I need to delete that and add the Street field, City field, State field, Zip field separately to me form?

  • Kevin Support Team Lead
    Replied on August 5, 2016 at 2:29 PM

    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.

     

  • Steven Kessler
    Replied on August 6, 2016 at 11:01 AM

    Thank you, Kevin.

    My goal is to allow Zapier to call each of the address fields separately and pass each on separately.  I tried putting your field codes into zapier's matrix, but they didn't work.   Can you show me how Zapier can plug into the individual address fields in JotForm?

  • Support_Management Jotform Support
    Replied on August 6, 2016 at 1:07 PM

    Hi Steven, I'm afraid you can't push the Address Field separately to Zapier. The solution given out by my colleague only applies to the following:

    1. Display each field, separately, on a Thank You Page

    2. Display each field, separately, on Email Notifications and Autoresponders

    3. Or send it through URL to another form or page

    Our Zapier trigger fetches the Address Field as a whole (treating it as a single field) along with all the other details of the submission.

    Separating Address field data Image 1 Screenshot 20

    If you wish to fetch them separately in Zapier, then the only workaround is to create your own textboxes for the complete address separately.

    You mentioned "I tried putting your field codes into zapier's matrix". If you could tell us to which platform you're setting up your Zap, we would better understand what your end goal would be. Or better yet, kindly explain to us your workflow and why you need to separate the Address Fields.

    Perhaps me and my colleagues can come up with a better workaround (if any). Hoping to hear from you soon.

  • stevenkessler
    Replied on August 6, 2016 at 2:10 PM

    Thanks for your help.

    I want to separate the different address fields so that in the future I can filter my contact list by state, city, or zip.  When promoting live events, it will be better to aim my marketing emails at people who live in the region, than at the entire nation.

    Unless you have a better workaround, I will create my own textboxes for each of the address fields.

  • Support_Management Jotform Support
    Replied on August 6, 2016 at 2:52 PM

    Thanks for getting back to us so quickly and for that bit of background on why you need the address fields separately :)

    To be honest, the best and most ideal approach is to use separate textboxes for your address fields. I took my time and fiddled around a handful of widgets related to addresses, checked them as a trigger in Zapier and all of them consolidate the fields into one single field.

    So, creating your own textboxes will be the way to go. In case you would need help with that, feel free to create a separate thread here so we can assist you.

  • roozbeh007
    Replied on April 2, 2017 at 10:15 PM

    Zapier's "Formatter" action is your solution. Use that to separate the address line data into separate value to be mapped out. luckily, JotForm separates each part of the address by a comma so your zapier formatter action trigger should be comma and then select all so it will separate the values for you. You can read more about it here: https://zapier.com/help/formatter/#using-split-text

  • Ashwin JotForm Support
    Replied on April 3, 2017 at 3:00 AM

    Hello roozbeh007,

    Thank you for sharing this information. I am sure it will help a lot of users.

    Thank you!