How do I create a multiple choice form with a scoring matrix based on user's answer?

I have a multiple choice form with 6 questions. Each question has 4 possible answers.

Based on people's answers, I want to assign them a score for 5 different Archetypes. The Archetypes would be calculated using numeric scores in hidden fields.

For example, if they select Answer A in Question 1, I want to use hidden fields to give them a +1 score for Archetype A, and a +1 score for Archetype B.

If they select Answer B for Question 1, I might give them a +1 score for Archetype C.

Then, in Question 2, the form would ADD to their scores for each Archetype depending on their answer.

For example, if they select Answer A for Q2, it would add 1 to their Archetype A score.

I am trying to do this using hidden fields and the Form Calculation widget, but this widget replaces the value of the Archetype A score instead of increasing it. How do I get it to increase it?

Also, at the end, how do I get the form to figure out which Archetype has the highest score?

Thank you!

Hi Seth,

Thanks for reaching out to Jotform Support. I'll need a bit of time to work out a solution. I'll get back to you as soon as I can.

Let us know if you have any other questions.

Hi Seth,

At the moment, Jotform's conditional logic doesn't have an incremental or built-in ranking feature. But you can still achieve this setup using a workaround. Start by assigning calculation values to each option in your questions, for example, assigning a value of 1 to each selected answer that corresponds to a particular Archetype.

Then, use hidden Form Calculation widgets after each question to act as containers that store the selected value. After that, add another set of hidden Form Calculation widgets to sum the values for each Archetype, giving you a total score per type. You can then use another hidden calculation widget with the max() function to identify the highest score, or the nth() function to rank the values accordingly.

Based on the outcome, you can apply Show/Hide Field conditions to either display the total score or show a paragraph describing the dominant Archetype. Note that in the case of a tie, Jotform will not automatically prioritize one result over another. In such cases, you’ll need to create additional conditions to define which Archetype should be displayed when two or more have equal scores. Check out the screencast below to see sample results:

You can check out and clone this demo form to see how the form works. If that’s not exactly what you’re looking for, let us know more details on how we can achieve what you're trying to do with your form.

Reach out again if you need any more help.

Hi Adrian,

Thanks for the help. I don't understand this step: "use hidden Form Calculation widgets after each question to act as containers that store the selected value."

For example, here are my Archetypes:

• Chat-First Host
• Explorer
• Fast Starter
• Pro Leader
• Structured Builder
  

Here is how my first question might be scored:

Q1. What kind of experience do you want members to have?

A. Fast, informal conversations-like a group chat -> Chat-First Host +2

B. Organized conversations with resources or learning -> Structured Builder +1; Chat-First Host +1

C. Access to exclusive content, perks, or programs -> Fast Starter +1; Structured Builder +1

D. A course-like or cohort-based journey -> Structured Builder +2; Pro Leader +1

My questions:

1. Are you suggesting that I have 5 hidden from calculation widgets after each of my 7 questions as placeholders, for a total of 35 hidden form calculation widgets, plus another 5 at the end to total up those Archetype scores, and then another to rank them, for a total of 41 hidden form calculation widgets?
2. What do I do when there are two choices that can contribute points to the same archetype, such as choices A and B above, which can both contribute to the Chat-First Host?
3. What do I do if a single choice can contribute a different number of points to different archetypes, such as choice D?

Thanks!

After the question, I have created a placeholder for the ChatFirstHost Archetype. But how do I tell the form calculation widget to add 2 to the widget if the selection is A, 1 if it's B, and 0 if it's C or D?

Yes, I could assign those values to each answer, but then how do I calculate the next Archetype, StructuredBuilder, where A=0, B=1, C=1, and D=2?

Hi Seth,

If you want to show a different thank-you page based on their Archetypes score? If yes, we need to add individual form calculation per options and another form calculation per archetypes, so the score will be combined, and you can get show the result based on what Archetypes is higher. Let me show you how to do it:

1. In Form Builder, click on Add Element on the left side part of the screen.
2. Under Basic tab, select Single Choice field and add it to your form 3 times.
3. Under Widgets tab, select Form Calculation widget and add it to your form (You need to add form calculation per option)
   
4. Next, we need to add 3 more Form Calculation widgets for total result.
   
5. Set the form like you see below:
   
   

Now, we will set a value on each option based on the selected answer by the user. (Ex: Users select A, we will add 2 points for Archetypes A and 1 point for Archetypes B). Let me show you how to do it:

1. In Form Builder, in the orange navigation bar at the top of the screen, click on Settings.
2. Click on Conditions on the left side of the screen.
3. Select the Update/Calculate Field condition.
   
   
4. Set the condition like you see below (You need to set up this to all options, and you can customize the value):
   
   

After we finish setting up a value for each option, we will now make a calculation for the total Archetypes. Let me show you how to do it:

1. In Form Builder, click on the Wand icon of your Form Calculation widget.
2. Click on the Add Field button and select the fields, then make sure to add + between the fields.
3. Then, click on the Save button.

Lastly, we will now create a customized thank you page that will display based on the user's total score. Let me show you how to do it:

1. In Form Builder, in the orange navigation bar at the top of the screen, click on Settings.
2. Click on Conditions on the left side of the screen.
3. Select the Change Thank You Page condition.
   
   
4. Set the condition like you see below (You need to set up this to Total Archetypes widget):
   

Check out the result:

You can check out this Demo Form so you can try it by yourself. If you want to clone the form, we've got a guide about How to Clone an Existing Form From a URL that will help you do it.

Give it a try and let us know how it goes.