Skip to main content
Participant
June 4, 2024
Answered

Javascript for Adobe

  • June 4, 2024
  • 1 reply
  • 263 views

Hello dear friends,

I have a task to calculate the percentage of fields in Adobe Acrobat PDF form containing status "Done".

There are following statuses:"Done", "Open", "Feedback". So I need to calculate the percentage of the  fields that will be filled with status "Done". The names of fields are "Status1", "Status2", .... "Status15".

I need to write customized Javascript and to be honest I am zero there. Can anyone help me with this ?

This topic has been closed for replies.
Correct answer try67

You can use something like this as the field's custom calculation script (set the field's Format to Percentage with the desired number of decimals):

 

var doneCounter = 0;
for (var i=1; i<=15; i++) {
	if (this.getField("Status"+i).valueAsString=="Done")
		doneCounter++;
}
event.value = (doneCounter/15);

 

1 reply

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
June 4, 2024

You can use something like this as the field's custom calculation script (set the field's Format to Percentage with the desired number of decimals):

 

var doneCounter = 0;
for (var i=1; i<=15; i++) {
	if (this.getField("Status"+i).valueAsString=="Done")
		doneCounter++;
}
event.value = (doneCounter/15);

 

Participant
June 5, 2024

Thank you a lottttt

It worked!