field conditional formatting

georgechen · ‎12-15-2015

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

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.

Manjul Katare · ‎12-15-2015

Hi George,

Here is how I would try to get the styles for any table field on the Form and also on the list view:

My field name is : "u_email_status" and the sys_choice are as follows:

Screen Shot 2015-12-15 at 8.29.21 PM.JPG

The styles are written as:

Screen Shot 2015-12-15 at 8.27.50 PM.JPG

Also,

Screen Shot 2015-12-15 at 8.40.55 PM.JPG

The list view looks something like this:

The Client script to get the color on the form is written as:

Screen Shot 2015-12-15 at 8.27.10 PM.JPG

The form looks something like this, when the [Valid Email = 0]

Screen Shot 2015-12-15 at 8.26.20 PM.JPG

Hope this help!

-Manjul

Michael Fry1 · ‎12-15-2015

It should be just 1 equal sign: current.u_email_status = '1'; - assuming 1 is the value of the choice you want set.

georgechen · ‎12-15-2015

Thanks Michael trying to assist. I have tried

current.u_email_status=='1' and current.u_email_status==1 in the value field, and it still behaves the same.

Michael Fry1 · ‎12-15-2015

Just use 1 equal sign: current.u_email_status = '1';

georgechen · ‎12-15-2015

still the same