- everbekeAsked on June 27, 2017 at 12:34 PM
I created a separate field for the zip code so I can base calculations from that individual field. Other than doing an update calculation field with numerous "If Zip code IS EQUAL TO 48083" then Calculate, is there way to create a list of zip code values and have a field check to see if the Zip Code matches one of the zip codes in the list? If so, then I would have a new field displayed based on the whichever list the zip code is found in and then add the delivery fee field into the total price calculations.Page URL:
- JotForm SupportKiranAnswered on June 27, 2017 at 02:08 PM
Unforutnately, it is not possible to have a list of zip codes to check and it would be difficult to perform calculations. However, you may consider using a dropdown menu for Zipcode so that you can assign the calculation values to the list and perform the calculation easily. Please refer to the guide below that can help you with assigning calculation values to the dropdown field.
Please give it a try and let us know if you need any further assistance. We will be happy to help.
- everbekeAnswered on June 27, 2017 at 03:43 PMYea..unfortunately I can’t ask my customers to pick their zip code from a list of over 160 zip codes, it just isn’t reasonable. It seems like there could be another solution.
- JotForm SupportKiranAnswered on June 27, 2017 at 05:08 PM
Unfortunately, there is no other workaround available for the issue. The only way to achieve to your requirement by setting conditions on the form using multiple rule set to display the new field and calculation.
If the fee is based on a continuous range of zip codes, you may consider using number field for Zip code so that you may setup the condition using less than and greater than values.