Calculation scores changing randomly on submissions

Hello Jotform,

https://form.jotform.com/81287041815153

 

https://form.jotform.com/81134987415159

 

ttps://form.jotform.com/81287961415160

 

We have the above three forms that we work with. Something strange has been happening where the scores will change once submitted. So, for example, in the "Tone and communication" section, if you click the first response for each question, the score for that section should read out as 14. Sometimes it reads out as 7 randomly. We have found that we can fix it by editing the form and re-clicking the first response for each question. This seems to correct the issue. 

Can you please let me know why the form would sometimes read out the wrong score (does not seem to be any pattern to this), why resubmitting it by clicking on the answers again fixed it and how to prevent this from happening in the future. 

 

Thank you. 

I have cloned your form and I noticed that the value for the Tone & Communication Score is calculated conditionally.

If the Contact Type is equal to Phone, the result will be 7, otherwise, it will be 14.

That makes no sense. If that were the case, it would happen all the time. Why does it only happen sometimes? And why would resubmitting it without changing anything, just re-clicking the same answers fix it?

There is an issue since you apply a calculation formula and mentioned by Adrian calculation conditions at the same time.

You should either use the calculation formula, or use the calculation conditions.

That makes no sense. If that were the case, it would happen all the time.
Why does it only happen sometimes? And why would resubmitting it without
changing anything, just re-clicking the same answers fix it?
...

The Tone & Communication Score field is a Form Calculation Widget field and it already has an expression in it. That field is also being calculated conditionally as I explained above.

In order to prevent any conflict between the calculation expression and the calculation conditions for that field, I suggest you add a Number field in your form to calculate the Total for that section. If the Tone & Communication Score is used somewhere else (in a calculation), replace it with the new Number field.

Then, edit the calculation conditions of the Tone & Communication Score to calculate the Number field instead.

Result:

Cloned Form URL: https://form.jotform.com/81726596548977

As you can see, the Number field is being calculated conditionally while the Tone & Communication Score field is being calculated by the expression in the Form Calculation Widget.

Thank you! What I am trying to understand is why this happens intermittently. 

What we would like to understand is how to make this not happen when we go back and edit submissions. We notice that it happens mostly when we edit. Any pointers that you can provide would be much appreciated. 

Thanks!

Gabriela 

Applying calculation conditions and calculation formula to the same field will lead to unpredicted results.

Example:

At the same time, you apply calculation conditions (with different calculation formulas) to the same field.

This is why it is not working as expected.

If the calculation formula in the field is correct, just delete the calculation conditions to fix the issue.

Alternatively, remove the calculation formula and stick with calculation conditions applied to the field.

Thank you.