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.


  • Profile Image

    Calculation based on dropdown selections

    Asked by OnePayroll 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

    Numeric Selection select numeric value
  • Profile Image
    JotForm Support

    Answered by Mike_T 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

    Answered by john.roscoe 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
    JotForm Support

    Answered by Welvin 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

    Answered by Garry   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

    Answered by Safefood360 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.