Spilt data from GeoComplete widget

  • wilhelmsendk
    Asked on March 23, 2017 at 4: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 

  • Kevin Support Team Lead
    Replied on March 23, 2017 at 8: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 

     

  • wilhelmsendk
    Replied on March 24, 2017 at 1: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? 

  • Nik_C
    Replied on March 24, 2017 at 4:33 AM

    Here is how my colleague did that:

    Go to Wizard of the Payment field:

    Spilt data from GeoComplete widget Image 1 Screenshot 30

    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:

    Spilt data from GeoComplete widget Image 2 Screenshot 41

    Hope it helps.

    Let us know if you have any further questions.

    Thank you!