Want Checkbox to Autofill Based On Information From Another Field

Question

I'm creating an employee evaluation form using Acrobat Pro DC. I have dropdown boxes for the evaluators to assign a ranking of 1 - 5 for each of twenty-five predescribed statements (e.g., "Excerses good judgement") in five categories (e.g., "Leadership", "Job Knowledge"). At the end of each category there is a field showing the average ranking for the five statements in that category. At the end of the categories there is a field (TotalAvgs) that tallies the five averages. Based on that total I wish to autopopulate a checkbox (or other type of box) in front of the applicable performance rating:

* Does Not Meet Expectations (<15)

* Meets the City's High Expectations (15-19.9)

* Exceeds Expectations (20-22.9)

* Far Exceeds Expectations (23-25)

I have written a few logic statements in Excel but don't yet understand how JavaScript works. Can anyone give me some pointers?

Not to be pesky but I forsee having two other questions, which I'll bring up after this one, related to Populating a header on all but the first page with the employee's name and How to have the document saved and emailed to the next approver of the evaluation after each signs (e.g. Supervisor, Department Head, HR, City Manager).

Thank you for any help.

try67 · Accepted Answer

PS. Are you sure the last check-box is not called "FarExceed"?

try67 · Answer

Use this code as the custom validation or calculation script of the TotalAvgs field:

var v = event.value;
this.getField("NotMeet").checkThisBox(0, (v<15));
this.getField("Meet").checkThisBox(0, (v>=15 && v<20));
this.getField("Exceed").checkThisBox(0, (v>=20 && v<23));
this.getField("FarExeed").checkThisBox(0, (v>=23));

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