Change the font color of a field based on its value

[dspolyglot]

Hello everyone,

Does someone know how to dynamically change the font color of a text column in a tabular report? For instance, I have a field named Indicator and it is the second column in the report. If the text value is equal to "Final", the font color must be set to red.

Thanks in advance.

-dspolyglot

[FlashD]

Hi dspolygot,

I have some jQuery code which can achieve this, just put the below code in the header of your DataPage(in Configure Results Page Fields):

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script>
$(document).ready(function(){
$("td:nth-child(2)").each(function () {

    if($(this).html() === 'Final')
        $(this).css('color','red');
});
});
</script>

Please note td:nth-child(2) is for second column if you want it for some other columns just replace 2 by the number of that column.

Cheers,

[vikovs]

Hi dspolyglot,

You may also check the solution from this article  -  just change the font colour instead of background colour.

 

[cheonsa]

Hello!

You can also use this script. Just paste it in the Footer:

<SCRIPT LANGUAGE="JavaScript">
var elems = document.querySelectorAll("td[class^='cbResultSetData']");
for (var i=0, m=elems.length; i<m; i++) {
if (elems[i].innerHTML == "Final") { 
elems[i].style.color="red";
}
}
</SCRIPT>