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

    Calculation values for Drop Down field adds first value to no option.

    Asked by jimchicago on August 08, 2015 at 08:24 PM

    I'm having an issue (similar to VACOGYD's) with a form I've built: http://form.jotform.us/form/52174831564154

    In this form, I've assigned values as follows to various selection options:

    In the "Package of Prints" dropdown:

    - Package #1 = 99

    - Package #2 = 69

    - Package #3 = 49

    - No Package = 0

    In the "Want a CD" dropdown:

    - Yes = 125

    - No = 0

    The "Total Price" field is to sum the values of the user's selections in these two fields, multiply the sum by 1.075, then add 25.

    So a user who selects Package #1 and Yes should see a "Total Price" of $265.80 . . . but instead the form shows a total of $233.65, because (I assume) it is using the 69 value of Package #2 in the calculation. How can I fix this?

    Also: How can I make a $ sign appear automatically on the far left inside the "Total Price" field? I went into the field's Properties and typed a $ in the Default Result box, but it doesn't seem to be working.

    And: Is it possible to prevent a number from appearing in the "Total Price" field before the user has made any selections (i.e, on page load)?

    Thank you.

  • Profile Image
    JotForm Support

    Answered by BDAVID on August 08, 2015 at 09:13 PM

    After further testing, I realized that the first value of 99 is assigned to an empty option, I tried cloning your form, clearing forms cache, but it did not work.

    I will report this to our second level for further help. Meanwhile, a temporary solution would be to add a "0" value first:

    -(empty)       =  0

    - Package #1 = 99

     

    - Package #2 = 69

     

    - Package #3 = 49

     

    - No Package = 0

    To make the "$" sign appear automatically on the left inside of the "Total Price" field, simply type it in the wizard:

    And in order to to prevent a number from appearing in the "Total Price" field before the user has made any selections, click on Show Advanced Options, and check Wait for input before including the field calculation option:

    This is how it will work: http://form.jotform.co/form/52198440855866

    You can clone my form example if you want to.

    Let us know if you need more help, we will be glad to assist you.

  • Profile Image
    JotForm Support

    Answered by Jan on August 09, 2015 at 09:08 AM

    Yes, that is correct. We will notify you via this thread once there is an update from our developers. Thank you for understanding.