sum to trigger a check box

18 replies
2212 views
Translate

Hi!

I'm trying to have a sum range trigger the showing of a check mark on a field.

For example if sum total is 19 a check mark will show up in box 1 because it is below 20.

If sum total is 28 a check mark will show up in box 3 becasue it is between 25-30.

I'm a novice at Adobe and your help is greatly appreciated!

PDF Automation StationCorrect answer

Community Expert

Enter the following custom calculation script in the Sum field and change the field names to match your check boxes:

event.value<20?this.getField("Check Box1").checkThisBox(0,true):this.getField("Check Box1").checkThisBox(0,false);
(event.value>19 && event.value<25)?this.getField("Check Box2").checkThisBox(0,true):this.getField("Check Box2").checkThisBox(0,false);
(event.value>24 && event.value<31)?this.getField("Check Box3").checkThisBox(0,true):this.getField("Check Box3").checkThisBox(0,false);
(event.value>40 && event.value<46)?this.getField("Check Box4").checkThisBox(0,true):this.getField("Check Box4").checkThisBox(0,false);
event.value>45?this.getField("Check Box5").checkThisBox(0,true):this.getField("Check Box5").checkThisBox(0,false);

PDF Automation Station

Correct answer

Community Expert

Enter the following custom calculation script in the Sum field and change the field names to match your check boxes:

event.value<20?this.getField("Check Box1").checkThisBox(0,true):this.getField("Check Box1").checkThisBox(0,false);
(event.value>19 && event.value<25)?this.getField("Check Box2").checkThisBox(0,true):this.getField("Check Box2").checkThisBox(0,false);
(event.value>24 && event.value<31)?this.getField("Check Box3").checkThisBox(0,true):this.getField("Check Box3").checkThisBox(0,false);
(event.value>40 && event.value<46)?this.getField("Check Box4").checkThisBox(0,true):this.getField("Check Box4").checkThisBox(0,false);
event.value>45?this.getField("Check Box5").checkThisBox(0,true):this.getField("Check Box5").checkThisBox(0,false);

Translate

E

Elena B RavenhillAuthor

Participating Frequently

Oh Whoa! Thank you!

When I run the above provided formula, it now removes the sum value (first option provided by the system) that was selected.

Is there a way to have both options? Sum and Custom?

Translate

Nesa Nurani

Community Expert

No, you can't have both options, but you can add the calculation to your current script, add this to custom calculation script (above your script):

var total = 0;
for(var i=10; i<=15; i++){
 var f = this.getField(""+i).valueAsString;
 if (f !== "" && !isNaN(Number(f)))
  total+=Number(f);}
event.value = total;

Translate

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.