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.
Calculation based on dropdown selectionsAsked by OnePayroll on March 18, 2014 at 01:25 PM
Is it possible to give a numeric value to a text-based dropdown selection and calculate with that?
Select your favorite pet: Cat (=1), Dog(=3), Horse (=5)
Select your gender: Male (=1), Female (=2)
So a female that likes dogs will get a score 3x2 =6
is it possible to setup something like this?
I have just answered a similar question here. Unfortunately, this is not currently possible, but we are looking into it and hope to implement some solution. I have attached a feature request ticket to this thread, so that your request will be noted as well.
If you can use Radio Buttons instead of Drop Downs, please see a workaround provided by Nicholas in this thread.
We will keep you updated.
There is a trap with this -
For radio buttons and text boxes the calculation values can be entered in the same way as the Options list, however for Drop down boxes, there is always a default blank line. So you need to offset the Values to match by making the first value '0'. You cant just leave a blank line because it will be deleted when you save.
Here is a screenshot to demonstrate, using the same values as above for both a dropdown box and a check box. Note the value in the dropdown for the 21" monitor is actually showing the value for product 3 because I didnt insert a 0 for the first value. The checkbox version is correct.
Thanks for reporting this to us. I checked it and I'm able to replicate the same. We can create a report ticket, but we'd request to please post this on a new thread. You can use this link: Contact JotForm Support .