field conditional formatting

[georgechen]

Hi folks

I am having an issue setting up a cell format right, here is the style

Table: sys_user

Field Name:   u_email_status

Value: javascript: current.u_email_status=='1'

Style: background-color: red;

the u_email_status is a string field based on sys_user table, with a choice list of the following options

Valid Email:	0
Invalid Email:	1
Do not send:	2

This condition is not working, but if I leave the value field blank, the field formats as RED, so I think the value has some issue with it.

Troubleshooting steps:

javascript: current.u_email_status=='1', no luck

javascript: current.u_email_status==1, no luck

javascript: current.u_email_status=='Invalid Email', no luck

javascript: answer = current.u_email_status=='1'; answer, no luck

Any advise would be appreciated.

[dave_edgar]

i found this mixed with a onChange client script allowed a async update to the colour if changed on screen for users which UX designers would love:

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

    if (newValue != oldValue) {

          return;

    }

  var color = g_form.getControl('yourfield');

  if(color.options[color.selectedIndex].value == "option1"){

  color.style.backgroundColor = "green";

  }

  if(color.options[color.selectedIndex].value == "option2"){

  color.style.backgroundColor = "red";

  }

  if(color.options[color.selectedIndex].value == "option3"){

  color.style.backgroundColor = "yellow";

  }

  if(color.options[color.selectedIndex].value == "option4"){

  color.style.backgroundColor = "grey";

  }

  if(color.options[color.selectedIndex].value == "option4"){

  color.style.backgroundColor = "pink";

  }

  if(color.options[color.selectedIndex].value == "option4"){

  color.style.backgroundColor = "orange";

  }

}

[georgechen]

Thanks David for sharing!