Skip to main content
Participant
Jun 4, 2024 9:55 PM UTC
Answered

Javascript for Adobe

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 is closed to new replies. Start a new post to keep the conversation going.
try67
try67Correct answer
Community Expert
Jun 4, 2024 10:01 PM UTC

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);

 

2 replies

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
Jun 4, 2024 10:01 PM UTC

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);

 

Translate
Participant
Jun 5, 2024 5:05 AM UTC

Thank you a lottttt

It worked! 

 

Translate