How to perform a form calculation using dropdown menu.

  • CEDCHIASSO
    Asked on July 1, 2015 at 4:32 PM

    I try to make calculation between two dropdown menu, each one numbered from 0 to 10.

    It seems does not works for me. You can see in the attachment what I want do do. What am I wrong?

     

    Thanks for your support.How to perform a form calculation using dropdown menu Screenshot 20

    Jotform Thread 601147 Screenshot
  • Mike
    Replied on July 1, 2015 at 6:49 PM

    Thank you for contacting us.

    Since you have the Drop Down options listed as numbers, you can delete the Calculation Values and it will still work. Alternatively, you will need to add a 0 option to the Calculation Values to have a correct calculation order (empty Drop Down items need the value too). 

    How to perform a form calculation using dropdown menu Screenshot 30

    Also, there is some problem with the Drop Down tags (first two Drop Downs). I would like to recommend you to update the field name tags. Then, you should be able to use them in calculations.

    How to perform a form calculation using dropdown menu Screenshot 41

    Please give it a try and let us know if you need any further assistance.

  • CEDCHIASSO
    Replied on July 2, 2015 at 4:53 PM
    Yes, that the first thing I have tried, but calculation field result is
    alwais 0. Could you please show how to have teh correct result on the
    calculation field?
    Thanks a lot for your quick support.
    Laurent.
    2015-07-02 0:44 GMT+02:00 JotForm Support Forum <
    noreply@jotform.com>:
    ...
  • David JotForm Support
    Replied on July 2, 2015 at 6:49 PM

    There was indeed something buggy with your fields.  I replaced your dropdowns with new ones and set the calculation up once again.  After replacing the fields the calculation worked.  Here is the form with the fields replaced:

    http://support.jotform.com/form/51826606487969

    You can clone it to have the updated fields and calculation:

    http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL