Spilt data from GeoComplete widget

  • Profile Image
    Asked on March 23, 2017 at 04:50 PM

    Hi jotform.

    I'm trying to get the zipcode from the geocomplete widget.

    I have copied the value into a text field , and my plan was to use the substring field to extract the zip code, but it dosnt work 

    In my text field i have the following format

    Street Name number,city,country,zipcode


    Is there anyway to extract the zip code from this field ?


    Thanks in advance 

  • Profile Image
    Answered on March 23, 2017 at 08:05 PM

    Unfortunately, I cannot find a way to split the data from the widget, the only possible solution would be to use the Form Calculation widget and set it to get the result as number, this way if the address has a zip code it will be taken, the only thing is that if the address has other numbers they will be also included. 

    If the zip codes would have the same length then would be possible to extract the zip code only using the SubString widget. 

    Here's the link to the form I was testing on: https://form.jotformpro.com/62286069523965 

    There are some widgets that will allow you to get the zip code only, you will find other mapping widgets on this link: https://widgets.jotform.com/category/mapping 


  • Profile Image
    Answered on March 24, 2017 at 01:21 AM

    Hi Kevin 

    Super that's just perfect. Almost what I needed.  Now just a substring then it works.  Hov did you get the number from where form calculation widget? 

  • Profile Image
    Answered on March 24, 2017 at 04:33 AM

    Here is how my colleague did that:

    Go to Wizard of the Payment field:

    When you add field you can set it to be Number or String. Those numbers next to the field name (0-9) and it's color means that it is a number field and it will be represented in that way.

    And Form Calculations Widget you can find in Widgets panel:

    Hope it helps.

    Let us know if you have any further questions.

    Thank you!