Copy link to clipboard
Copied
How do I get a total number of check boxes?
They are named:
Check Box 1.0 - 1.9
Check Box 2.0 - 2.9
Check Box 3.0 - 3.9
Check Box 4.0 - 4.9
Check Box 5.0 - 5.9
In that case you can use this code as the custom calculation script of the field where you want to show the result:
var total = 0;
for (var i=1; i<=5; i++) {
var fields = this.getField("Check Box "+i).getArray();
for (var j in fields) {
if (fields[j].valueAsString!="Off") total++;
}
}
event.value = total;
Copy link to clipboard
Copied
I'm assuming you mean the ticked check-boxes... If not, the answer is 50.
Copy link to clipboard
Copied
Yes, total number of ticked check-boxes. Thank you 🙂
Copy link to clipboard
Copied
In that case you can use this code as the custom calculation script of the field where you want to show the result:
var total = 0;
for (var i=1; i<=5; i++) {
var fields = this.getField("Check Box "+i).getArray();
for (var j in fields) {
if (fields[j].valueAsString!="Off") total++;
}
}
event.value = total;
Copy link to clipboard
Copied
Sorry - but any chance of dumbing that down for me ... I'm unsure of where that script needs to go for it to work? I have a Total Boxes Checked line for the number to go - but unsure of how to apply that script to that total line.
Appreciate all your help!
Copy link to clipboard
Copied
Go to the Properties of the field, Calculate tab and put that code under the third option, "Custom calculation script".