I want to extract the zipcode so i can calculate a price from zipcodes

  • wilhelmsendk
    Asked on August 27, 2018 at 8:19 AM

    Hi jotform . 

    I know this issue has been raised many times, but i hope you have found a solution on this .

    I have a geocomplete field, that works fine , and then i have the update / calculate field where i send the data from the geocomplete field . ( i use the cards setup )

    I want to extract the zipcode so i can calculate a price from zipcodes . 

    My format is Høvej 62, Lystrup, Danmark, 8520  . Is there anyway to extract the zipcode 8520 from a text field ? i have a comma as you can see and then the zipcode .

    If i use a substring i will get both the housenumber and zipcode and that dosnt work 


    any idea to how this can be done ?

     
  • Richie JotForm Support
    Replied on August 27, 2018 at 11:30 AM

    I have checked your form and it seems you're using a multi-line question for your zip codes.

    I want to extract the zipcode so i can calculate a price from zipcodes Image 1 Screenshot 50

    You can use the UPDATE/CALCULATE condition to get the value of your zip code.

    1.) Select which field you want to get the value

    I want to extract the zipcode so i can calculate a price from zipcodes Image 2 Screenshot 61

    2.) You use the STATE is Filled, so that when the field is filled it will get the value.

    I want to extract the zipcode so i can calculate a price from zipcodes Image 3 Screenshot 72

    3.)We copy the fields value ,add a field and in the Summary we select the field we want to show the copied value.

    I want to extract the zipcode so i can calculate a price from zipcodes Image 4 Screenshot 83

    Sample Form:https://form.jotform.com/82384363938973

    Please give it a try and let us know how it goes.

    Thank you.