Send email based on majority of answer

Hello, I created a jot form with automated mails, but i am facing an issue. The issue is i would like my respondents to receive an automated mail according to the highest number of a particular option they have chosen (for example if A was picked the most in there response, the automated mail for A should be sent). But it happens that, for each option they choose, the automated mail is sent even if it is chosen once and that is wrong. So i would like to be told how to fix the automated response

Hi Lea,

Thanks for reaching out to Jotform Support. Allow me to look into this and I will get back to you with an update as soon as possible.

In the meantime, let us know if there's anything else we can help you with. Thank you for your patience.

Hi Lea,

Thanks for reaching out to Jotform Support. I checked your form, and found that all emails are sent because the condition is set to send an email even if an option is only selected once. See following example, where the Email for Option D is sent, if in any of the questions, a user selects the 4th option:

Since you already have Form Calculation widgets on your form, we will instead utilize them in the conditions, but first, we need to make a few adjustments. We will need to use an Input Table, because for every answer, we will add a score in the corresponding cell, and we will sum up each column to compare with each other for the email. Let me show you how:

1. In Form Builder, click on Add Element and find the Input Table.
2. Add it to your form, then click on the Gear icon to open the Properties.
3. Change the Input Type in Fields Tab to Numeric Input.

4. Update the rows, make 5 rows and name them based on the number of questions.
5. Update the 4 columns, and change their names to A, B, C, and D.

Then, disable all the conditions in your form:

1. Click on Settings from the top navigation bar.
2. Select Conditions from the left menu.
3. Click the Select All button, then click Disable.

Next, add the conditions to tabulate the answers:

1. Click the Add Condition button.

2. Select Update/Calculate Field, and set it as follows (the condition means that if A is selected in the first question, then cell A in the first row will record 1) :

3. Add for when B is selected in the first question:

Keep adding conditions like this. This means that for every question, there's 4 Update/Calculate Field condition, one for each option.

Once done with the conditions, sum up every column:

1. Click the Wand icon of the Form Calculation widget.
2. Remove everything, then click on Add Field.
3. Select the Input Table, and select the whole column (Column A for Count A).
4. Add Plus sign between them, before clicking on Save.

The calculation should look like the image below. Make sure to update the rest of them as well:

Finally, add the conditions for the email. For sending the email if the answer is mostly option A:

Notice that we have added three If statements, to compare it with each Form Calculation widget, and that the rule is set to All. Do this for the other emails as well.

That's it. Here is my clone form which you can check and clone.

Give it a try and let us know if you need any help.

Thank you very much for the guidiance
I have done it successfully, but i came accross a small error
I could not select any of the option for my third question

Hi Lea,

I cloned your form and tested it to see if I could replicate the issue, and I ran into the same issue. When I looked at your form, I saw that one of the conditions for that question wasn't configured correctly. Let me show you how to fix it:

1. Select the question, then click on the Condition button.
2. Find the condition for when the answer is Feeling fully present then click the Pencil button.

3. Update the condition as follows, then click on Save.

That's it. Let us know if you have any other questions.