Change formatting of Table Row based on field value

I want to set conditional formatting on the Priority field on the standard Task object. If the priority is High, I want to add a class to the HTML element so that I can apply custom CSS through the class. I’ve read various posts here that are similar to this need, but I’m having trouble extrapolating from them. My attempt so far is to use a custom field renderer on the Priority field in my table of Tasks and to call the JQueryUI function addClass(). Here’s my inline snippet that I’m using as the custom field renderer. Am I in any way on the right track? var field = arguments[0], value = arguments[1]; if (field.mode == ‘read’ && field.value == ‘High’) { field.addClass(“highpriority”); }

Glenn, You are on the right track. I think that you just need to try “field.element.addClass” and you should see your extra CSS show up.

That makes sense, but it hasn’t changed the result, which is that no values are being rendered for the field at all. I’ve attached a screenshot.

You are almost there. The main piece you’re missing is to call the default field renderer (in bold): var field = arguments[0], value = skuid.utils.decodeHTML(arguments[1]); skuid.ui.fieldRenderers[field.metadata.displaytype]field.mode; if (field.mode == ‘read’ && value == ‘High’) { field.element.addClass(“highpriority”); } The other problem was that you need to use value, not field.value.

I added that in, and the data now renders again, but my class is not being added when the value is High. Hmmm.

I think I’ve cracked it. This seems to work having changed the bold bit: var field = arguments[0], value = skuid.utils.decodeHTML(arguments[1]); skuid.ui.fieldRenderers[field.metadata.displaytype]field.mode; if (field.mode == ‘read’ && value == ‘High’) { field.element.addClass(“highpriority”); }

Yes, this tests well, so consider this one answered. This is a very neat solution for conditional formatting.

Oops — just looked at my answer and the problem was, as Glenn figured out, that you want to use “value” instead of “field.value”. I’m changing my answers so that future viewers of this post will not be confused.

This reply was created from a merged topic originally titled change the font color of a row in table based on condition. I’d like to change the color of the text in a row to red if a checkbox on the record it TRUE (i.e. hot lead).  see picture attached.

Several have asked for this to be more completely fleshed out. Here we go. I’m building a lead page where if the “do not call” field is set, the background of the row turns light red. Here are the steps:

  1. Make sure you have the “do not call field” in your model and in your field.

  2. Go to Resources Tab of the pallet and add A Javascript resource of type “In LIne-Snippet” Give snippet a memorable name. I used “HighlightRow”

Here is the code for the Snippet:

var field = arguments[0], value = skuid.utils.decodeHTML(arguments[1]); skuid.ui.fieldRenderers[field.metadata.displaytype][field.mode](field,value); if (field.mode == 'read' && value === true) { field.item.element.addClass("LeadTab\_highlighted-row"); }
  1. Then add a CSS Resource of type “in-line”. The code for this should be:

    table.nx-skootable-data tbody tr.LeadTab_highlighted-row td { background-color: LightCoral; }

  2. Go back to your table and select the “do not call” field. In the field properties change the field renderer to bhe “Custom (run a Snippet)” This will add a new property called “Render Snippet Name” Here type what you called your Javascript resource in step 2. Again I used “HighlightRow”

Save your page and enjoy the results.

To help out with your work, I have pasted this page in our page repository. Copy this xml into a new page in your org and check it out.

I’ve followed these steps, and the render is correctly applying the css class, but my table doesn’t change.

Here’s the css:

table .nx-skootable-data tbody tr .highlightLate td {
background-color: LightCoral;
}

Even if I inspect and manually change the style of the row, nothing changes:

<tr class="nx-item highlightLate" style="background-color: lightcoral;">

Any idea what’s going on here?

I’ve got this working on a table, but would like to have the row highlight drive by a boolean field that I don’t want to show in the table - essentially a hidden field for each row. I can make the column narrow, but is it possible to have the snippet run from a field not in the table?

As long as you have the boolean in your model the syntax at the beginning of your snippet would need to look like this: 

var field = arguments[0]; var value1 = arguments[1]; var row = field&#46;row; var value2 = row&#46;FieldName; 


Then do all your evaluation on value2 field. 

Thanks, yes that worked fine.

Glad to hear! 

Does anyone know how I can make this work for the detail page? I would like to highlight the page the user clicks on the record that DoNotCall is selected. Thanks

I just wanted to comment to help anyone who had the same problem as me. This particular example only applies to things in a “read” mode. So, for my situation I was trying to make things change color when it was in “readonly” which means the examples all failed.

I just needed to change this bit:

field.mode == ‘read’

to

field.mode == ‘readonly’

and my highlighting worked.


I am sure this is a stupid problem, but it caught me out for an hour and I wanted to save someone else an hour.


Korey, I’ve run into the same problem before. Thank you for including this!!

Korey.  Thanks for saving folks an hour! 

Matt, this was a while ago. I’m guessing you probably already figured this one out? I think it’s just an issue of where the class and styles are being applied. Since the JS snippet adds the class to the item(which is associated with the tr element), your css selector should say tr.highlightLaterather than tr .highlightLate (the highlightLate class applied to the tr rather than the child of the tr). As for manually adding the style, the style should actually be applied to each td that is a child of the trrather than the tr itself. Just for future reference! :slight_smile: