Javascript for auto populating a text field based on the value from another field.

Question

I have a form set up for users to score individuals in 8 categories. At the bottom of the form, I have created a field that adds up all of the previous scores that I'll refer to as TOTAL SCORE. I now want to create a text field that will automatically display certain text (5 possible values) when the value of TOTAL SCORE falls within a certain range.

For example,

If the TOTAL SCORE field is > 16, I want the text box field to automatically populate to say "UNACCEPTABLE".

If the TOTAL SCORE field is between 16-23, I want the text box field to automatically populate to say "NEEDS IMPROVEMENT".

If the TOTAL SCORE field is between 24-31, I want the text box field to automatically populate to say "MEETS REQUIREMENTS".

If the TOTAL SCORE field is between 32-39, I want the text box field to automatically populate to say "EXCEEDS REQUIREMENTS".

If the TOTAL SCORE field is equal to 40, I want the text box field to automatically populate to say "OUTSTANDING".

try67 · Accepted Answer

Assuming so, you can use this code as the custom calculation script of the field where you want to display the result:

var totalScore = Number(this.getField("TOTAL SCORE").valueAsString);
if (totalScore<16) event.value = "UNACCEPTABLE";
else if (totalScore>=16 && totalScore<=23) event.value = "NEEDS IMPROVEMENT";
else if (totalScore>=24 && totalScore<=31) event.value = "MEETS REQUIREMENTS";
else if (totalScore>=32 && totalScore<=39) event.value = "EXCEEDS REQUIREMENTS";
else if (totalScore==40) event.value = "OUTSTANDING";

try67 · Answer

In the first line, do you mean if TOTAL SCORE is < 16 ?

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