How to count filled fields

You can create a function to replicate the Excel function that returns the non-empty count. This function can be placed as a document leve l funtion or folder level fucntion. Then for the individual field or other use you would only need to call the function with a list of the fields to be tested.

// document of folder level function
function CountA() {
/*
Count the non-empty fields, up to 256 fields
Inputs: field names passes as argument to this function
Returns: count of non-empty fields
*/
var nCount = 0; // number non-empty fields
// loop through this functions augment array
for (i = 0; i < arguments.length; i++) {
if (this.getField(arguments[i]).value != '') nCount++; // increment non-empty field
} // end loop
return nCount; // return count
} // end CountA function
// end document or folder level function


// field custom calculation script
event.value = CountA('duty1', 'duty2', 'duty3', 'duty4','duty5');

That's great, thanks!

Donna

The code worked perfectly when I used it to count the number of text fields that had been filled in. However, I ran into a snag with a set of fields that had numeric ratings in them ranging from 0 (Unsatisfactory) to 4 (Outstanding). It looks as if the code can't count the field as filled if it has a 0 in it instead of being blank. The fields have to be numeric because later on the numbers get added together then divided by the number of fields that were filled in to get an average score.

I've tried some minor variations on the code myself to no avail, but I don't really understand how Javascript handles numeric fields versus text fields. Any thoughts would be appreciated!

Donna

You can use the 'valueAsSting" rather than the "value" property to test for an empty field.

Perfect! Thanks so much for all your help.

Donna

I think this is the answer I need for my form as well, however, I don't understand where the code should be located for either scenario, the folder level or the form level.

Any help would be greatly appreciated.

Thanks