Need Script Help With Adding Yes/No Columns

[raypalmer]

Im trying to add all the "Yes" and all the "No's" in each column. I'm using the following script that does not seem to work for me. 

var total = 0; for (var i=1; i<=60; i++) { var fields = this.getField("Check Box "+i).getArray(); for (var j in fields) { if (fields[j].valueAsString!="Off") total++; } } event.value = total;

I named the check boxes 1-60 the same for each question with a differant value in each (yes,no), so the end user can not check a yes and no for the same answer. Need a little help on this script. Not sure what I'm doing wrong. 

[try67 · Accepted solution]

This script is not quite what you need. Use this:

var total = 0;
for (var i = 1; i <= 60; i++) {
	var f = this.getField("Check Box "+i);
	if (f.valueAsString=="yes")
		total++;
}
event.value = total;

Note that JS is case-sensitive, so "yes" and "Yes" are not the same thing...

[raypalmer]

That did the trick. Thank you so much!!!!!!!