- OnePayrollAsked 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?
- JotForm SupportMike_TAnswered on March 18, 2014 at 03:48 PM
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.
- john.roscoeAnswered on March 28, 2014 at 09:34 PM
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.
- JotForm SupportWelvinAnswered on March 28, 2014 at 10:11 PM
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 .