Copy link to clipboard
Copied
I have 31 text boxes, one for each day of the month. In each text box there are 5 or 6 different entries, such as P, T, AB, AT. I want to create a field to total the P's and T's but not the AB's and AT's. How do I do that?
OK, then you can use this code as the custom calculation script of the total field:
var total = 0;
for (var i=1; i<=31; i++) {
var v = this.getField("Smith "+ i).valueAsString;
if (v=="P" || v=="T") total++;
}
event.value = total;
Edit: Forgot to add a space after "Smith"...
Copy link to clipboard
Copied
What are the names of those fields?
Copy link to clipboard
Copied
Smith 1 through Smith 31
Copy link to clipboard
Copied
OK, then you can use this code as the custom calculation script of the total field:
var total = 0;
for (var i=1; i<=31; i++) {
var v = this.getField("Smith "+ i).valueAsString;
if (v=="P" || v=="T") total++;
}
event.value = total;
Edit: Forgot to add a space after "Smith"...
Copy link to clipboard
Copied
That worked. Thanks try67. You are a rock star!!