Skip to main content
E
Erin5C66
Participant
February 19, 2021
Answered

Calculating number of filled fields

  • February 19, 2021
  • 2 replies
  • 7138 views

Hi all,

Long time lurker, first time poster. I am working in Adobe Acrobat Pro 2017, and created a fillable PDF for employee appraisals. To calculate the employee's score at the end of the form, I need to calculate the number of fields where text was entered (like the Excel "COUNTA" function) so I can divide that by the added total of ratings. I have everything figured out except the custom calculation script for totalling the number of fields that have text entered in them. I've spent the past 8 hours deep in the weeds in Google and this support community and have found numerous similar scenarios, but I can't get any of those scripts to work. I'm old, my brain is fried, I know zilch about JavaScript and would really, REALLY appreciate any insight or help.

 

For reference, the fields are named COM.01 through COM.18, and I just need to count the total number of fields containing text, leaving out any COM. fields that are blank.

 

Thanking you in advance.

This topic has been closed for replies.
Correct answer Nesa Nurani

Change the value of one of those fields and then check the JS Console (Ctrl+J) for error messages.

If you can't figure it out please share the file with us for further help.


See if this works for you:

var total = 0;
var fields = this.getField("COM").getArray();
for (var i=0; i<fields.length; i++) {
var f = (fields[i]).valueAsString;
if (f !="") total++;
}
event.value = total;

2 replies

B
BRLIPNER
Participating Frequently
June 12, 2024

I'm not real good with Excel.. where do 
I put the calculation code..?  Please give more details.

Nesa Nurani
Community Expert
Nesa NuraniCommunity Expert
Community Expert
June 12, 2024

This is for Adobe Acrobat, not Excel.

try67
Community Expert
try67Community Expert
Community Expert
February 19, 2021

You can use this code as the custom calculation script of your text field:

 

var total = 0;
var fields = this.getField("COM").getArray();
for (var i=0; i<fields.length; i++) {
	if (f.valueAsString!="") total++;
}
event.value = total;

 

If you want it to immediately display the relative amount of filled-in fields to the total, change the last line to:

event.value = total/fields.length;

    E
    Erin5C66Author
    Participant
    February 19, 2021

    Thank you very much. I copied and pasted that into the field where I need the result, but nothing happened when I entered text into the "COM." fields.

    E
    Erin5C66Author
    Participant
    February 19, 2021

    Edit: I pasted it into the custom calculation script in the field where I  need the result. I AM TIRED, lol.

     

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices