Validation Script Help
I'm using the following validation script which compares the input argument against the "IC Ref" value and fills the field red or green depending on whether it is greater or less than the "IC Ref" value.
The problem is that if you input a IC Ref value and fill in the form fields then go back and change the IC Ref value the fill colors do not refresh based off of the new IC Ref value.
Is there a way to get the validation to update based off of a new IC Ref value being entered?
var v = Number(event.value);
var ic = this.getField("IC Ref").value;
if (v>0 && v<=ic) {event.target.fillColor = color.green;}
else if (v>ic) {event.target.fillColor = color.red;}
else event.target.fillColor = color.white;
