How to return a string based on a value in the box next to it?

[codyr6422869]

Hello, 

I am making a dynamic form and I want the field "ScoringKey" to return a string based on a score that is calculated in the field next to it, "FinalScore". Is this possible? I cant seem to get the field "ScoringKey" to return a string no matter the parameters.

Basically

• if final score is greater than 1.00 but less than 1.99 return “Unsatisfactory”
• If final score is greater than 2.00 but less than 2.99 return “Needs Improvement”
• If final score is greater than 3.00 but less than 3.99 return “Meets Expectations”
• If final score is greater than 4.00 but less than 4.99 return “Exceeds Expectations”
• If final score is equal to 5.00 than return “Outstanding”

This is what I have for code:

if (FinalScore < 2 && FinalScore > 0.99) text = "Unsatisfactory";

if (FinalScore < 3 && FinalScore > 1.99) text = "Needs Improvement";

if (FinalScore < 4 && FinalScore > 2.99) text = "Meets Expectations";

if (FinalScore < 5 && FinalScore > 3.99) text = "Exceeds Expectations";

if (FinalScore === 5) text = "Outstanding";

[Bernd Alheit]

Where do you set the variable FinalScore?

[try67 · Accepted solution]

Add this line to the start of your code:

var FinalScore = Number(this.getField("FinalScore").valueAsString);

And this line to the end of it:

event.value = text;

[codyr6422869]

That worked perfectly, thank you!!