What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Is it possible to calculate price based on drop down selections?

    Asked by dotransferme on January 16, 2017 at 03:35 PM

    Hi, we are trying to create order form, which will allow user to order transfer service from one to different location.

    Currently we have 10 location in two different dropdown fields and user can choose which one is pickup and which one is destination location. Price must be provided to user based on his/her selection

     

    We need to provide price for combination of two drop down selections. e.g.

     

    Dropdown 1

    a, b, c, d, e, f, g, h, i, j

     

     

     Dropdown 2

    a, b, c, d, e, f, g, h, i, j

     

    a+d=$10 or a+c=$20

     

    can anyone assist us and advice how to create this

    Thank you in advance!

    Page URL:
    https://form.jotform.me/70155223802446

  • Profile Image
    JotForm Support

    Answered by Kevin_G on January 16, 2017 at 06:15 PM

    Yes, this will be possible to achieve with conditions, I have created a sample form based on your example, basically what you need to do is to set the condition statements, setting the condition that all the statements need to be met, and then add the needed value. 

    Here's my sample form: https://form.jotform.com/70157483407962 

    You can clone it by following this guide: How-to-Clone-an-Existing-Form-from-a-URL

    Here's also a guide with more details about this feature: Conditional-Logic-Inserts-Text-Calculation-Into-A-Field

    Do note that you will need to set all the combinations that you need in your form, each combination of options will end up in a condition. 

    If you have any question, let us know. 

  • Profile Image

    Answered by dotransferme on January 17, 2017 at 05:00 AM

    Thanks a lot Kevin_G!

     

    Please be so kind to inform me which is the best solution for price output field!

  • Profile Image
    JotForm Support

    Answered by ashwin_d on January 17, 2017 at 06:01 AM

    Hello dotransferme,

    You should use normal "Textbox" field or "Form Calculation" widget to display the price output.

    Please note that there is an alternative solution also available to calculate the price without adding any conditions. Here are the steps you should follow:

    #1. Add two dropdown field in your form and set the "Calculation Values" for each dropdown options you add. 

    #2. Add a "Form Calculation" widget in form and set the formula to add the values of both the dropdown fields. Please check the screenshot below on how to achieve this:

     

    Please take a look at the following demo form and see if this is what you want to achieve:  https://form.jotform.com/70162652478964

    Feel free to clone this form for a closer look. The following guide should help you in form cloning:  https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!

  • Profile Image

    Answered by dotransferme on January 17, 2017 at 07:37 AM

    Thanks ashwin_d, 

     

    Please be so kind to advice me how we can add price (for example $50) to the total price when customer check checkbox.

     

    To be sure You understand what we are talking about: We have checkbox field "Order VIP Transfer" (this is optional field) when customer check this field we want system to add automatically $50 to "Transfer Price" field which already have some price based on user's selected two drowdowns 

    https://form.jotform.me/70155223802446

     

    Hope to receive any advice soon!

    Thanks

  • Profile Image
    JotForm Support

    Answered by Jim_R on January 17, 2017 at 09:28 AM

    Hello, since your most recent question is now different from the topic being discussed here, I moved to it to a separate thread https://www.jotform.com/answers/1036761

    We'll have it addressed there shortly.