Copy link to clipboard
Copied
Hi community,
I'm trying to write a custom calculation script for a field, based upon the values entered into a second field. I'm getting a syntax error that I can't solve. I am sure that I have some sort of simple error that is causing it to fail. Here is my script:
var SS = this.getField("Score - Safety").value;
if ( SS >= 97) event.value="A+";
else if (SS >= 93) && (SS < 97) event.value="A";
else if (SS >= 90) && (SS < 93) event.value="A-";
else if (SS >= 87) && (SS < 90) event.value="B+";
else if (SS >= 83) && (SS < 87) event.value="B";
else if (SS >= 80) && (SS < 83) event.value="B-";
else if (SS >= 77) && (SS < 80) event.value="C+";
else if (SS >= 73) && (SS < 77) event.value="C";
else if (SS >= 70) && (SS < 73) event.value="C-";
else if (SS >= 67) && (SS < 70) event.value="D+";
else if (SS >= 65) && (SS < 67) event.value="D";
else event.value = "FAIL";
Copy link to clipboard
Copied
Solved by parentheses.
var SS = this.getField("Score - Safety").value;
if ( SS >= 97) event.value="A+";
else if (SS >= 93 && SS < 97) event.value="A";
else if (SS >= 90 && SS < 93) event.value="A-";
else if (SS >= 87 && SS < 90) event.value="B+";
else if (SS >= 83) && SS < 87) event.value="B";
else if (SS >= 80 && SS < 83) event.value="B-";
else if (SS >= 77 && SS < 80) event.value="C+";
else if (SS >= 73 && SS < 77) event.value="C";
else if (SS >= 70 && SS < 73) event.value="C-";
else if (SS >= 67 && SS < 70) event.value="D+";
else if (SS >= 65 && SS < 67) event.value="D";
else event.value = "FAIL";
Copy link to clipboard
Copied
Solved by parentheses.
var SS = this.getField("Score - Safety").value;
if ( SS >= 97) event.value="A+";
else if (SS >= 93 && SS < 97) event.value="A";
else if (SS >= 90 && SS < 93) event.value="A-";
else if (SS >= 87 && SS < 90) event.value="B+";
else if (SS >= 83) && SS < 87) event.value="B";
else if (SS >= 80 && SS < 83) event.value="B-";
else if (SS >= 77 && SS < 80) event.value="C+";
else if (SS >= 73 && SS < 77) event.value="C";
else if (SS >= 70 && SS < 73) event.value="C-";
else if (SS >= 67 && SS < 70) event.value="D+";
else if (SS >= 65 && SS < 67) event.value="D";
else event.value = "FAIL";