Custom Calculation Formula Needed

4 replies
846 views
Translate

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?

Acrobat SDK and JavaScript

This topic is closed to new replies. Start a new post to keep the conversation going.

try67Correct answer

Community Expert

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"...

try67

Community Expert

What are the names of those fields?

Translate

paulh77730136Author

Participant

Smith 1 through Smith 31

Translate

try67

Correct answer

Community Expert

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"...

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.