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

  • Profile Image
    StudioBe
    Asked on July 22, 2015 at 02: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!!  

  • Profile Image
    abajan
    Answered on July 22, 2015 at 03: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:


    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:


    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

  • Profile Image
    grade4pagasa
    Answered on July 22, 2015 at 03:42 PM

    related question. 

    i understand if a new thread will be created for this. 

    can a selected radio button or dropdown box's value be shown in a textbox field in words (instead of numbers)? 

     

  • Profile Image
    Mike_G
    Answered on July 22, 2015 at 04: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.