use the calculate function to count items in a list

Question

I have a form that will be used for entering names and times worked.  The list could have anywhere from 1 to 21 names at any given time.  I'm trying to find a calculation that will give me the total number of names entered on the list.  Any ideas?

try67 · Answer

Let's say the name fields are called Name1 to Name21. You can use this code as the custom calculation script of the field where you want to display the total number of names entered:

var total = 0;
for (var i=1; i<=21; i++) {
    if (this.getField("Name"+i).valueAsString!="") total++;
}
event.value = total;

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