How to set up a quiz with multiple scores using Rating Scale questions and Formula fields

There are multiple ways to create a quiz in AidaForm. Different approaches can help you create your desired quiz in the easiest way possible. Any approach makes it possible to collect your respondents’ names and emails before displaying the results of the quiz.

1. Trivia quizzes with multiple-choice questions, right/wrong answers and a total score. Read more
2. Quizzes with rating scale questions and multiple scores. The approach is ideal for creating personality and Enneagram-like tests to define which personality type the respondent belongs to.
3. Quizzes with multiple-choice, picture choice, drop-down, rating scale fields, and multiple scores. This approach allows you to create what-suits-you-better tests and quizzes. It provides you greater space for creativity, but requires more time to create. Read more

This tutorial provides information about the second approach. Take the quiz to see the flow and what the results look like. Click the Use Template button to add the quiz to your account and review all settings. Use it as an example or a template — customize any part of the quiz to make it your own!

Click the Use Template button to add the quiz to your account and review all settings. Detailed instructions below will help you to set up a new quiz as well as adjust settings for the existing template.

How it works

This quiz asks questions in order to determine which personality type the respondent belongs to. The quiz has nine personality types, but you can have as many types as you need.

Each question on the quiz contributes to one personality type. At the end of the quiz, you can display what scores your respondent got for all existing types, show the highest score that identifies the respondent’s prevailing personality type, or both.

Rating scale fields to ask questions

To ask questions, the quiz employs Rating Scale fields only. Questions provide statements and respondents have to choose how strongly they agree or disagree with the statement on a scale from 1 to the figure of your choice.

Example: the question is “I am a perfectionist.” The answer options range from Disagree to Agree:

You can add as many rating questions to your quiz as you need.

Formula fields to calculate scores

Each question is used to calculate the score for one personality type. A question contributes the value of the chosen option to the scale: 1 (Disagree), 2, 3 (Neutral), 4 or 5 (Agree).

Our quiz example has 36 questions. And they are used to calculate scores for nine personality types: Type 1, Type 2, Type 3, … Type 9. Four questions for each personality type.

To calculate a score for a personality type, we need to use the Formula field, which will add up values collected from four questions.

It’s very easy to calculate a score with the Formula field:

1. Add the Formula field to your form
2. Name the field
3. Use the @ function to calculate the sum from the contributing fields

To calculate scores for nine personality types, we need to add nine Formula fields to our form.

How can I find a maximum score?

To show your respondents the highest score that identifies their prevailing personality type, you need to find out which of the nine personality type scores is higher.

To find the maximal score, we use one more Formula field (that you can name Result Type) and use an easy math.js function that will do all the work:

m = max(@Type1, @Type2, @Type3, @Type4, @Type5, @Type6, @Type7, @Type8, @Type9);

Use the @ function to insert names of your personality type formula fields into the function. Read more about how to use the Formula field.

How can I display a result page with the description of the respondent’s personality type after the quiz is submitted?

You can set conditional After Submit redirects! You will find this functionality in the Builder -> Set Up -> After Submit section, but first you will need to do the following:

1. Create separate pages with images and descriptions of every personality type for your quiz. In our example, we have created nine pages to cover all cases. This is one of the pages:
2. Add some conditional steps to the Result Type formula field to define the name of the type that has the maximum score. The conditional steps look like this: Condition ? A : B , which returns A if the Condition is true and B otherwise.

For example, the line t = m == @Type1 ? 1 : t; asks if the maximum is Type 1. If yes, then the result value is 1, if not, the result value left unchanged.

Why do we need 0? Because we need a starting point for comparison.

Now the Result Type formula field not only determines the maximum value, but knows which of the personality type is assigned to it. The Result Type field looks like this:

Please note that we must use semicolons to separate lines. The last line must not have a semicolon!

After doing this, everything’s ready to set up conditional After Submit redirects and display pages with custom content and, maybe, special offers for your respondents.

Please visit the Builder -> Set Up -> After Submit section of our example quiz to see what it can look like. Here is just a small part to illustrate the general idea: