Conditional fields if one field is empty, the others to be empty also, if not empty, for it to have a percentage or grade.

[amandac10107247]

I want the second line to be empty if the marks (like it is now) to be empty. I have this in the % field under progress at the moment (where the 17 currrently is)

((DataTest +StudentInvestigation)/30)*100

and in the result section I have this.

var perc = this.getField("Percentage2").valueAsString;

if (perc=="") event.value = "";

else {

    perc = Number(perc);

    if (perc<25) event.value = "E";

    else if (perc<45) event.value = "D";

    else if (perc<65) event.value = "C";

    else if (perc<85) event.value = "B";

    else event.value = "A";

}

I'm not sure how to add the "if ___ field is empty" part to it.

[try67]

Do you mean for the first calculation? You can use something like this:

var s1 = this.getField("DataTest").valueAsString;

var s2 = this.getField("StudentInvestigation").valueAsString;

if (s1=="" || s2=="") event.value = "";

else event.value = ((Number(s1)+Number(s2))/30)*100;

[amandac10107247]

Yes thank you,

and the Grade field as well.

[try67]

The script above already does that.

[amandac10107247]

Yes it does for the percentage, but in the result field it still comes up with an "E" even though the percentage is nothing.

[amandac10107247]

Oh never mind, its because I did the input wrong for the last one. Thank you again.

[amandac10107247]

Hi,

Sorry now, when I change the numbers it doesn't update the grade in the result section.

[try67]

Check the JS Console (Ctrl+J) for error messages.