Calculation: How to calculate repetition of character, selected by user

Hi,

https://form.jotform.com/241565124819055

We are building like an assessment or quiz form. The result will be based depending to the user's answer using single choice. I put calculation widget, calculation condition and hidden fields.

I attached the Scoring keys.

Hi DigitalYMC,

Thanks for reaching out to Jotform Support. Can you explain a bit more about your scoring key and how you'd like the quiz results to be calculated? Also, how many points is each category equivalent to?

Once we hear back from you, we'll be able to move forward with a solution.

Thank you for your response. Actually there is no score, the result will be depending on the majority of their answers. For example, this is the answer of the user 1c, 6a, 7c, 8c, 10a, 11b, 12a, 15d, 17a, 20c 
his assessment result will be Innovation & Creativity.

Hello DigitalYMC,

I understand what you’d like to do, but I’ll need a bit of time to work if it is possible using calculation widget and assigning calculation values. I’ll get back to you shortly.

Hello,

I would like to update the status of this ticket?

Thank you.

Hi DigitalYMC,

I have reached out to my colleague Eldrex, and he is still working on it. He will get back to you as soon as he can.

Thanks for your patience and understanding, we appreciate it.

Hello DigitalYMC,

We really appreciate your patience and understanding while we look into this. Unfortunately, the workaround that I have tested only applies to the total number of answers and not in a set-up that you have showed. However, you can still calculate the answers based on the highest among the options. For example, in 20 questions, the form user has answered a total of 20 letter A's then you can set it to show that he is in Innovation & Creativity.

If this meets what you are looking for then I can show you how to do it in detail.

As soon as we hear back from you, we can move forward with a solution.

Thanks Eldrex! I'll get back to you regarding this ticket.

Hi Eldrex,

"For example, in 20 questions, the form user has answered a total of 20 letter A's then you can set it to show that he is in Innovation & Creativity."

Can you show me how to do your solution?

Follow-up question, how about when the user just answer a total of 15 A's?

Hi DigitalYMC,

I understand the issue, but I’ll need a bit of time to work out a solution. I’ll get back to you shortly.

We really appreciate your patience and understanding while we’re looking into this.

Hi DigitalYMC,

While the feature you’re looking for isn’t currently available, rest assured we’re always working to add new services and features to Jotform. I've gone ahead and escalated your request to our Developers. When or if it's implemented depends on their workload, how viable it is, and how many other users request it. As a workaround, we can add short fields and increase value of whatever option selected by user & at the end we can calculate all of individual answers and based on condition we can find the greater value and show phrase/scoring keys to user. Let me walk you through it, step by step:

Adding 4 fields and update value of field based on Selected option

1. In Form builder, click on the Add Form Element menu on the left side of the page.

2. Under the Basic tab, scroll down the list and choose the Short text field.

3. Now, just drag and drop it to your form, you will have to add 4 same fields against each question.

4. Select Short text field & click on Gear icon.

5. Under Advanced tab, toggle to shrink and hide field.

6. Copy field and paste it 3 more times, rename for different options.

7. While In Form builder, select Settings at the top.

8. In the menu that opens on the left side of the page, click on Conditions.

9. Click on + Add condition and choose Update/Calculate field.

10. Set Condition as below picture:

• If the selected answer is A:

• If the selected answer is B:

• If the selected answer is C:

• If the selected answer is D:

Add calculation widget to calculate repetition of each answer

1. In Form Builder, click on the Add Form Element menu on the left side of the page.

2. Under the Widgets tab, enter Form Calculation in the search bar, and drag and drop the widget to your form.

3. Select Form Calculation widget and click on Gear icon.

4. Under Advanced tab, toggle to hide the widget.

5. Select Form Calculation widget and click on Wand icon.

6. Click on + Add Field and choose all A answer's fields.

7. Repeat Step 1-6 for B, C & D options.

Adding Headings to show Scoring Key.

1. In Form builder, click on the Add Form Element menu on the left side of the page.

2. Under the Basic tab, scroll down the list and choose the Heading field.

3. Now, just drag and drop it to your form

4. Select the heading field and click on Gear icon.

5. Under General tab, toggle to hide field.

Configuring Condition to Show Scoring Key

1. In Form builder, select Settings at the top.

2. In the menu that opens on the left side of the page, click on Conditions.

3. Click on + Add condition and choose Show/Hide Field.

4. Set condition as below picture:

• If A is repeated most.

• If B is repeated most.

• If C is repeated most.

• If D is repeated most.

You can check out the demo form. If you want to clone the demo form, you can easily do that. This Guide will show you how to do that. We also have a guide about How to Insert Text or Calculation Into a Field Conditionally that you can check out. We also have a guide to help you learn How to Show or Hide Fields Conditionally.

Give it a try and let us know if you have any other questions.