I am creating a type of KPI scoreboard that will tell the user what type of level they are currently operating in depending how they respond to four questions. I have set it up so that:
Column 1 = Strongly Disagree = 0
Column 2 = Disagree = 1
Column 3 = Agree = 2
Column 4 = Strongly Agree = 3
I figured out how to calculate the sum of the check marks which shows up instantaneously. My problem is that the Level Description associated with each sum does not continuously update like the sum does.
When the sum is 0 "Not Started" shows:
But when I change the box selection, the sum changes but the words don't:
Here is my current code:
// custom variable name for the level description
// establish the name of the sum field
var cSum = 'EESUM';
// get the value of the sum field
var nSum = this.getField(cSum).value;
// set level description
if(nSum == 0) event.value = "Not Started";
else if((nSum > 0) && (nSum <= 4)) event.value = "Beginning";
else if((nSum > 4) && (nSum <= 6)) event.value = "Learning";
else if((nSum > 6) && (nSum <= 8)) event.value = "Performing";
else if((nSum > 8) && (nSum <= 11)) event.value = "Achieving";
else if(nSum == 12) event.value = "Excelling";
// end of script
Please help me find a way to continuously update the text box. Is a while loop needed?
The code is fine. It seems to be a field calculation order issue. You need
to make sure that the score in words field is calculated after the score in
On Thu, Mar 12, 2015 at 8:35 PM, niah37410507 <firstname.lastname@example.org>
How do I change this? I thought by having get the EESUM field first that the score in numbers was being calculated first.
In Form Edit mode click on Other Tasks - Set Field Calculation Order.