IF THEN Statement for Performance Evaluation Form
I am trying to add an IF, THEN statement for my performance evaluation form. Basically what I need to happen is that if an "X" is place in any of the 5 columns (i.e., poor, good, great, better, best, each worth a number of 1-5 respectively), then in the score column it will reflect a number between 1-5. So if there is an "X" in the Poor column, the Score should equal 1; If there is an "X" in the Good column, the Score should equal 2 etc.
I wrote the following but so far, only the last line works:
var A = this.getField("ConsistentlyBelow1").value
var B = this.getField("BelowExpectations1").value
var C = this.getField("MeetsExpectations1").value
var D = this.getField("ExceedsExpectations1").value
var E = this.getField("ConsistentlyExceeds1").value;
if(A=="X") event.value=((1))
if(B=="X") event.value=((2))
if(C=="X") event.value=((3))
if(D=="X") event.value=((4))
if(E=="X") event.value=((5));
else event.value=0
