Count Total Number of Check Boxes

[kaylalaurencia]

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

[try67]

I'm assuming you mean the ticked check-boxes... If not, the answer is 50.

[kaylalaurencia]

Yes, total number of ticked check-boxes.  Thank you 🙂

[try67 · Accepted solution]

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;

[kaylalaurencia]

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! 

[try67]

Go to the Properties of the field, Calculate tab and put that code under the third option, "Custom calculation script".