Participant

Answered

Can the check boxes calculate a percentage number of items completed in PDF?

Forum|Forum|3 years ago
May 9, 2023
2 replies
2802 views

I have a simple list with checkboxes.

Is there a way to calculate a percentage complete based on the number of checkboxes were checked in one row?

If one checkbox is checked then it gives 25$

If two then 50%

If three then 75%

If all checked then 100%

This topic has been closed for replies.

Correct answer AhmedCOSTA

Then you need to hard-code them into the script, like this:

var fields = ["KW MB POP - Dr 1", "KS MB POP - Dr 1", "QT MB POP - Dr 1", "OM MB POP - Dr 1"];
var total = 0;
for (var i=0; i<fields.length; i++) {
	if (this.getField(fields[i]).valueAsString!="Off") {
		total++;
	}
}
event.value = total/fields.length;

[Edited: Code fixed]

SUPPER

It works great, just add the first two lines

var max = 4;
var total = 0;
var fields = ["KW MB POP - Dr 1", "KS MB POP - Dr 1", "QT MB POP - Dr 1", "OM MB POP - Dr 1"];
for (var i=0; i<fields.length; i++) {
	if (this.getField(fields[i]).valueAsString!="Off") {
		total++;
	}
}
event.value = total/fields.length;

U

unisd53018312

Participating Frequently

Hello, I would like to ask for assistance on my matter, it's similar to AhmedCOSTA's.
Calculate the percentage of the checkboxes.
For example; I have 19 checkboxes in total and if all of them are marked as checked. I want the field to get the percentage of 100%.

I followed Try67's code but I got the result 1,163% despite not ticking any of the boxes.

Nesa Nurani

Community Expert

I don't see where you declared 'total' variable?

Other than that it looks ok, although it could be done slightly different.

U

unisd53018312

Participating Frequently

I see it now. Thank you, Nesa!
I made a mistake in not including the 'total' variable.

Do you know how to keep that field blank if there's no checkboxes being ticked?

Thanks again.

try67

Community Expert

Sure. Let's say the fields are called Drink1 to Drink4. You can then use this code for that calculation:

var max = 4;
var total = 0;
for (var i=1; i<=max; i++) {
	if (this.getField("Drink"+i).valueAsString!="Off") {
		total++;
	}
}
event.value = total/max;

You'll also need to set the text field as having the Percentage format.

A

AhmedCOSTAAuthor

Participant

Hi try67,

This is supper, Thanks alot.

But, what if the fields name is diffrent like:

KW MB POP - Dr 1

KS MB POP - Dr 1

QT MB POP - Dr 1

OM MB POP - Dr 1

try67

Community Expert

Then you need to hard-code them into the script, like this:

var fields = ["KW MB POP - Dr 1", "KS MB POP - Dr 1", "QT MB POP - Dr 1", "OM MB POP - Dr 1"];
var total = 0;
for (var i=0; i<fields.length; i++) {
	if (this.getField(fields[i]).valueAsString!="Off") {
		total++;
	}
}
event.value = total/fields.length;

[Edited: Code fixed]

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