Calculation based on dropdown selections

  • Profile Image
    OnePayroll
    Asked on March 18, 2014 at 01:25 PM

    Hi,

    Is it possible to give a numeric value to a text-based dropdown selection and calculate with that?

    For instance:

    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?

     

    Kind regards

    Pieter

  • Profile Image
    Mike_T
    Answered 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.

  • Profile Image
    john.roscoe
    Answered 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.

    example

  • Profile Image
    Welvin
    Answered 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 . 

    Thanks

  • Profile Image
    Garry  
    Answered on November 13, 2014 at 04:22 AM

    Can the calculations property be added to the Configurable List widget? That would be very handy.

    Cheers

    Garry

  • Profile Image
    Safefood360
    Answered on August 12, 2015 at 02:37 PM

    The dropdown box offset issue that john.roscoe reported is still present and had caught us too. Thanks john.roscoe for sharing this. Its a pity after almost a year and half that Jotform have not fixed this bug.