Has anyone ever tried making some kind of "scoring mechanism" in Nintex Forms?
Question 1 choice: A B or C --> in case A the score will be '-1', in case B score '2' and so on. But then for more questions .
I would like to show the scores on the form. That when one picks an option it appears in the column next to it. And in the end the total score should be calculated and displayed.
I'm a bit stuck on this... It's working fine when I would use input number fields where one could enter the appropriate score and the form generates the sum using a calculated field. But I actually do not want users to be filling them out manually as mistakes could happen.
I already tried using a form variable and a calculated field... did not work out as I am actually not sure what function(s) to use.
Any brilliant ideas or tips? Otherwise I will use a workflow to take care of the calculations, but in this business case it would be an added value if it would be possible in the form itself.
Solved! Go to Solution.
Here's the formula that you can use:
Use this formula in the calculated field in Integer format. 2,3,4 are the values for each options and 3.00 is the weightage of each score if you need. At the end create another caluclated field to sum the results. Hope this helps.
To be honest I immediately changed the double quotes to the single ones (it works). With other rules I mostly ran into troubles when trying to use double quotes and most of the time the use of single quotes resolved the issue. Not sure though about what the standard naming convention is... anyone? :-)