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

    Is it possible to associate a numerical value with a radio button in a Matrix form field

    Asked by ocfoa on June 11, 2012 at 05:02 PM

    I'm creating a sample performance evaluation form for football officials. We want to use terms like "Exceeds Expectations", "Meets Expectations" and "Needs Improvement" for 4 different areas of performance. The matrix works really well for this.  At the end of the season, we want to be able to tally the overall score for each official and average the rating.  We'd like to have a numeric value associated with each rating. 3 pts for "Exceeds Expectations", 2 pts for "Meets Expectations" and 1 pt for "Needs Improvement".  These points will be averaged over the total number of evalutions that the official received for the season. For instance if an official is rated 3 times and his total score is 30, his average score will be 2.5 (30 divided by 3 divided by 4). We can do the averaging using the Excel export and using an Excel function but we need to have a field that carries that numeric value. Any suggestions?

    Page URL:
    http://jotformpro.com/form/21625315735956

  • Profile Image
    JotForm Support

    Answered by jonathan on June 11, 2012 at 06:33 PM

    Hi,

    I am not sure if this can be useful on your end, but I tried it on mine and using Excel report, -- I can get the "equivalent" numerical value for the evaluation answer using the excel formulas.

    I have it like this:

    =IF(J2="Exceeds Expectations",3,IF(J2="Meets Expectations",2,IF(J2="Needs Improvement",1)))

    "J2" was the cell that refer to "Referee Evaluation" 1st question... I just expanded the formula on the excel sheet and changed "J2" into the appropriate cell address(eval question)

    Hope this help in anyway.

    I will try also on google spreadsheet integration if the same formula will work.

    Please inform us if this is not what you need. 

    Thanks.

  • Profile Image
    JotForm Support

    Answered by jonathan on June 11, 2012 at 07:26 PM

    Hi,

    Updated:

    The formula will also work if applied to a form integrated to google spreadsheet.

    FYI

    Thanks.

  • Profile Image

    Answered by ocfoa on June 12, 2012 at 09:09 PM

    Jonathan, thank you for the quick response. I'm still revising the format of the evaluation, I will give this a try as soon as I've got it somewhat solidified. Looking at your solution, I don't see why it wouldn't work, I will post an update as soon as possible.