Personality Quiz - Count How Many Times Same Letter Is Chosen

Hello! I am creating a personality quiz for our brand.

I would like the quiz to see what answer was chosen the majority of the time and give that as their personality type.

Example if client picks majority letter A - they will be assigned personality A.

Assigning numbers to the types does not work as it then creates a large range for me to calculate as well have 8 personalities. I do not want to assign 1-8 to these and then have to calculate different ranges.

I do not want a scoring system like this A = 1-10, B= 2-20, as this has too many variables for 8 types.

I want it to be simple, If A is majority, You are type A.

What is the best was to determine this?

Hi Ashley,

Thanks for reaching out to Jotform Support. I'll need a bit of time to provide you a method and an example. I'll be back to you in this thread as soon as I can.

Thanks for your patience and understanding, we appreciate it. 

Thanks Frédéric, Any progress?

Checking in again...

Hi Ashley,

There is no update yet from my colleague. I will reach out to him and we’ll get back to you as soon as we have an update.

Hi Amy,

I've moved your question to a new thread and will be helping you out here.

Let us know if you have any other questions.

Hi Ashley,

We apologize for the delay in the reply. Achieving your requirement will take some configuration. To explain it, I'll use an example form, however, you should be able to follow the instructions easily.

The first thing is to configure the calculation values. If you have 8 outcomes, you will have to one decimal for every additional option. For example, for the first option, you need to add 1 as the calculation value, for the second option, it should be 10, third one should be 100, and all up to the eight option, which should be 10000000. Here's how to configure this:

1. Once you open your form in the Form Builder, click on the Gear Icon next to the one you wish to configure.
2. Open Options tab.
3. Enable Calculation values.
4. Enter values here, as described previously.

You will have to repeat this for every question you wish to include in the result.

Now, we need to add a calculation to calculate the sum:

1. While still in the Form Builder, click on Add Element from the left side of the builder.
2. Open the Widgets tab.
3. Click or drag Form Calculation widget to add it to your form.

Here, you need to add all the fields that you have, and add an additional 100000000 (in case you have 8 options). To achieve this:

1. Click on the Gear icon next to the form field.
2. Select the blue Add Field button, and add each individual field.
3. Ensure there is a plus between each field.
4. At the end, add an additional 10000000. You can use your keyboard or the virtual keyboard from the widget for this.

You will now get a long number. You can ignore the first digit. Every other digit represent how many time an option on that position was selected. As you can see in the screenshot below, the last option was selected 3 times, so the last digit is 3. The option before the last one was selected only once, so the digit next to 3 is 1:

The next step would be to extract these individual numbers. For this, we need to get ID of the calculation field:

1. Click on the Gear icon next to the calculation field.
2. Open the Advanced tab.
3. Scroll down and copy the Field IDs value.

Now, let's add Substring widget:

1. Click on the Add Element button from the left side of the builder.
2. Select Widgets tab.
3. Search for Substring.
4. Click or drag the widget to add it to your form.

Here's how to configure the widget:

1. Click on the Wand icon next to the widget.
2. Under the Source field ID paste previously copied field ID.
3. Substring start should have the value 8.
4. Substring end should have the value 9.

You will have to add a Substring widget for every option you have. In your case, you should have total of 8 widgets. Substring start and end should decrease by one for each additional one you add.

Finally, you need one more calculation field that will show the highest value:

1. Add another calculation field, following previous instructions.
2. Click on the purple f function button to open available functions.
3. Search for the max function, and click to add it.
4. Add all substring widgets in the calculation, separating them with a comma. Ensure to click on the comma, so the background changes from gray to black, as shown in the image below.

The final step is to configure conditions to properly show text based on the result. For this, I have added a paragraph field for all available outcomes. Although you are using Card forms, you can use the same field in your form.

1. Click on the Settings from the top orange bar.
2. Select Conditions from the left menu.
3. Click on Show/Hide Field.

You need to check if the calculation field with the max value is equal to the related substring widget, and if so, show the related paragraph:

You will have to repeat this for all substring widgets you have. You can test out my example form here. Feel free to clone it to get access to all conditions and other settings.

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