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"...
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
AdChoices