I want to highlight or color a field when it's empty, how do you do it?
I've been trying out this formula but I think it's not correct because there's a Syntax Error:
var a1 = this.getField("FirstN");
if (a1.value == null)
a1.style.backgroundColor = "yellow";
You have quite a lot of errors there... Try this code (as the field's custom validation script):
event.target.fillColor = (event.value=="") ? color.yellow : color.transparent;
Retrieving data ...