• Global community
• Language:
• Deutsch
• English
• Español
• Français
• Português
• 日本語コミュニティ
Dedicated community for Japanese speakers
• 한국 커뮤니티
Dedicated community for Korean speakers
Exit
• Custom Calculation Formula Needed

# Custom Calculation Formula Needed

New Here ,
Dec 28, 2018 Dec 28, 2018

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?

TOPICS
Acrobat SDK and JavaScript

Views

449

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Community Expert , Dec 29, 2018 Dec 29, 2018

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

4 Replies 4
Community Expert ,
Dec 28, 2018 Dec 28, 2018

Copied

What are the names of those fields?

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
Dec 28, 2018 Dec 28, 2018

Copied

Smith 1 through Smith 31

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Expert ,
Dec 29, 2018 Dec 29, 2018

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

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
Dec 29, 2018 Dec 29, 2018

Copied

LATEST

That worked.  Thanks try67.  You are a rock star!!