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

  • jimchicago
    Asked on August 8, 2015 at 8: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.

  • David JotForm Support Manager
    Replied on August 8, 2015 at 9: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

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

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

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

    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:

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

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

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

    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.

  • Jan
    Replied on August 9, 2015 at 9: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.