-
wilhelmsendkAsked 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 LeadReplied 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
-
wilhelmsendkReplied 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_CReplied on March 24, 2017 at 4: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!