Count Number of fields IF field is filled-in vs blank

Question

Hi! I am looking for code that I can put in the "Custom Calculation Script" section of the Text Field Properties in Acrobat Pro DC.

Part of the form I am creating has six fields:

String 1 - No.

String 2 - No.

String 3 - No.

Total Strings

String 4 - No.

String 5 - No.

String 6 - No.

Total Strings

I need to know how many fields get used, not the sum total of what's in the fields. For instance, if the user types:

String 1 - No. = 8

String 2 - No. = 10

String 3 - No.

String 4 - No. = 12

String 5 - No.

String 6 - No.

I need to know how many the first three strings are used (2) and how many from the second three strings are used (1).

String 1 - No. = 8

String 2 - No. = 10

String 3 - No.

Total Strings = 2

String 4 - No. = 12

String 5 - No.

String 6 - No.

Total Strings = 1

try67 · Accepted Answer

You can use something like this for the first group, as the custom calculation script of the total field:

var count = 0;
for (var i=1; i<=3; i++) {
	var v = this.getField("String "+i+" - No.").valueAsString;
	if (v!="") count++;
}
event.value = count;

And then just change the starting and ending numbers in the loop for the second group.

ls_rbls · Answer

Do you already have a code that you've worked on and can share here ? This may be possible using an array method to count how many  text fields  are not empty (or null, or blank if you prefer).

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.

Scanning file for viruses.

This file cannot be downloaded