Is It Possible to Have Numbers Associated with Selections, so That They Can Be Used in Calculations?

  • StudioBe
    Asked on July 22, 2015 at 2:03 PM

    Hey guys, I am wondering if Jotform has evolved enough to allow for selections to be associated with numbers? So in other words, can I make a field where "yes" = to 1 or "no" = 0 for calculation purposes?

    I am working on a bonus form for my employees. One of the questions is "Was Monthly Goal Hit?". If the user answers "Yes", then I would like the form to use a calculation to double the total bonus. I cannot figure out how to make that calculation work. Ideally, I could associate the "Yes" with a 2x multiplier when calculating the total bonus. Hope this makes sense.

    If Jot doesn't have the capabilities to do this, is there a work around? Thanks!!  

  • abajan Jotform Support
    Replied on July 22, 2015 at 3:23 PM

    Yes, we have evolved. Moreover, the evolution continues with more neat stuff being added all the time!

    Anyway, to illustrate the desired functionality I've created this short demo. If you clone it and look at the Calculation Values field in the properties of the radio button field, you'll see the numbers 2 and 1 for the Yes and No selections respectively:

    Is It Possible to Have Numbers Associated with Selections, so That They Can Be Used in Calculations? Image 1 Screenshot 30


    Also note that the tag indicated for the name of that field appears in the following screenshot of the Your bonus will be field's calculation expression:

    Is It Possible to Have Numbers Associated with Selections, so That They Can Be Used in Calculations? Image 2 Screenshot 41


    When the Add Field button is clicked, you will see that tag representing the field. For longer forms containing many fields, it can sometimes be confusing to know which tag belongs to which field. As such, those tags can be edited by clicking them.

    If you need more help with implementing the functionality, we'd be happy to provide it.

    Thanks

  • Mike_G JotForm Support
    Replied on July 22, 2015 at 4:34 PM

    @grade4pagasa

    I have moved your concern to a new thread. We believe that we can better assist a single user if they have their own thread. Thank you for understanding. You can click this link to go the new thread created for you.