How can I add a delivery fee based on a list of zip codes I have?

  • everbeke
    Asked 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.

  • Kiran Support Team Lead
    Replied on June 27, 2017 at 2: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.

    https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

    Please give it a try and let us know if you need any further assistance. We will be happy to help. 

     

  • everbeke
    Replied on June 27, 2017 at 3:43 PM
    Yea..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.
    Emily Verbeke
    emverbeke@gmail.com
    ...
  • Kiran Support Team Lead
    Replied on June 27, 2017 at 5: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.

    How can I add a delivery fee based on a list of zip codes I have? Image 1 Screenshot 20

    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.