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.

[Michael Fry1]

So without any value, the color red will show on both list and form view. With value, only list view. So for the value, just put 1, nothing else. Then look at list view.

[georgechen]

without any value, the color red will apply to form view, but in list view it applies to field with a value entered, (see below)

Form view

List view

It would be great if we know value to be set so the condition applies to form view when the value is 1 which is Invalid Email.

[Manjul Katare · Accepted solution]

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:

The styles are written as:

Also,

The list view looks something like this:

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

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

Hope this help!

-Manjul

[georgechen]

Thanks Manjul, your suggestion works like a charm. did not realise the client script has to come and play in the form style formatting.

Many thanks.

[Manjul Katare]

I'm glad I could help you with it, feel free to ask any followup question you may have.

-Manjul