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>

 

[Kurumi]

Hello - Just wanted to share another way to dynamically change the color of the calculated value/field when a condition is met using CSS.

You can insert this in the Header:

<style>
span.cbFormCalculatedField:has(+ input[name="cbParamVirtual1"][value="No"])  {
  color: #2543be;
}

span.cbFormCalculatedField:has(+ input[name="cbParamVirtual1"][value="Yes"])  {
  color: #29be25;
}

</style>

If you have more conditions or other fields, you can use this:

<style>
span.cbFormCalculatedField:has(+ input[name="cbParamVirtual1"][value="No"])  {
  color: #2543be;
}

span.cbFormCalculatedField:has(+ input[name="cbParamVirtual1"][value="Yes"])  {
  color: #29be25;
}

span.cbFormCalculatedField:has(+ input[name="InsertRecordFIELDNAME"][value="Inactive"])  {
  color: #2543be;
}

span.cbFormCalculatedField:has(+ input[name="InsertRecordFIELDNAME"][value="Active"])  {
  color: #29be25;
}
</style>

Hope it helps!

[Kurumi]

 Hi! You can also use this CSS code in other Form Elements:

Text Field and Email

<style>
input[name="InsertRecordFIELDNAME"][value="Active"] {
  color: green;
}
</style>

Display-Only field

<style>
span.cbFormData:has(+ input[name="InsertRecordFIELDNAME"][value="Active"]) {
  color: green;
}
</style>

 

[RuisiHansamu]

Hi There, there is an updated article in Caspio that you can check. It dynamically  change the colors of the value. https://howto.caspio.com/tech-tips-and-articles/dynamically-changing-colors-of-values/