[HubertJ]

Hi,

I am trying to style a field (make text bold and red) whenever value This is a cached copy. Click here to see the original post.

[Veda]

hi,

you can meet your requirement by using a separate custom field of type “inlineHTML”. Value of the inlineHTML field needs to be set using CASE statement based on your requirement.

In the script example below, we have set different colours for number range 50

CASE

WHEN (TO_NUMBER({custom_Field_Name})<25) THEN

'

‘ || trim({custom_Field_Name}) || ‘

‘

WHEN (TO_NUMBER({custom_Field_Name})<50) THEN

'

‘ ||trim({custom_Field_Name}) || ‘

‘

ELSE

‘

‘ || trim({custom_Field_Name}) || ‘

‘

END

thanks,

Veda.

[HubertJ]

Veda,

thank you very much for your help.

Where do you put that case statement? I put it in default value field in Validation & Defaulting ?

Is it a proper way or there is a better way to do that ?

—

Regards,

Hubert

[pcutler]

Hubert, the validation & defaulting section is the right location for that.

To offer one other option, if you’re using saved searches to display data you can also bold/highlight fields on the highlighting tab of the saved search.

[HubertJ]

pcutler,

thank you for your answer. I’ve used highlighting tab on the saved search but it will highlight the whole row not one field.

Is there a way to highlight one field on saved search ?

[pcutler]

You’re correct, the highlighting feature would highlight the whole row. If you need to highlight a single field, you can use Veda’s approach from above in a “Formula Text” search column field.

[rnedelkow]

SuiteAnswer 18393 also includes an example for cell and column highlighting based on conditions in saved search.

[HubertJ]

Thank you !!!

[Author]

Posts