struggling with a survey form calculation

Hi, I am struggling with a survey form that I created that needs to capture responses and based on the response, provide a category. I have tried using Settings>Conditions>Conditional Logic and also the Build>Properties>Options Widget Settings for the Calculations and still no luck. I think I am close as I am getting values in the fields. But it is either overwriting the values instead of adding them together with each option selected, or I am not getting a value at all.

Each question has 3 responses that I aligned to a value. Based on the responses, I wanted the total calculated and assigned to one of 3 categories and then show the result based on the count. Do you have any suggestions or help guides that you can point me to? I have tried several different help guides and none seem to cover this scenario and I think I am missing something.

Any help will be greatly appreciated.

Hi Herbs,

Thanks for reaching out to Jotform Support. I'm an AI assistant here to assist you.

It sounds like you want to capture responses in your survey form, calculate a total score based on those responses, assign a category based on the total, and then display the result accordingly. Let me help you with that:

1. Assign values to each response option: Make sure each answer choice in your questions has a numerical value assigned. You can do this in the field properties or using the Options Widget Settings for calculations.
2. Create a Calculation field: Add a Form Calculation widget to your form to sum up the values from each question. Use the widget's calculation settings to add the values together rather than overwrite them.
3. Set up Conditional Logic: Go to Settings > Conditions and create conditions based on the total calculated value. For example, if the total is between certain ranges, assign a category by showing a specific field or message.

For detailed step-by-step instructions on how to use conditional logic to show or hide fields based on answers, you can check this helpful guide on displaying questions based on selected answers.

Here is a quick overview of the process:

1. In Form Builder, add the fields you want to calculate and assign values.
2. Use a Calculation widget to sum the values.
3. Set conditions to show or hide category fields based on the calculated total.

This approach prevents overwriting values and ensures the total is correctly calculated and used for category assignment.

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

Hello,

I'd be happy to help with your question! I cloned your form and noticed that the question fields did have calculation values, but I also saw that they are listed out in an X / Y / Z format. This is not a recognized format, so the questions are passing a value of 0, or null. I also observed that the Form Calculation widgets at the bottom did not have any calculations within them, nor were their values getting changed by conditions. As such, the Form Calculation widget values remained at 0, which is what is causing the issue.

Considering that you want to calculate which Path a user should be assigned, the best way to implement this functionality is likely via conditional logic, where a specific answer adds a value to the subsequent Form Calculation widget. An example would be in the first question. Answering with the first option adds to CalcA, answering with the second option adds to CalcB, and answering with the third option adds to CalcC. Here is an example of what one scenario would look like. This would add a value of +1 to the CalcA field based on the user's response to the first question.


Once you have all the conditions set up, each of the answers will subsequently add to the 3 calculation widgets you have. You can then use your existing conditions to calculate which path to send a user down based on those 3 calculation widget values.

Let me know if this makes sense and helps with your issue!