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

  • Profile Image
    jimchicago
    Asked 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
    BDAVID
    Answered 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
    Jan
    Answered 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.