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

[hannahb8849908]

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]

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

[try67 · Accepted solution]

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

[hannahb8849908]

Awesome! Thank you, it's working great!