Jump to content

Change the font color of a field based on its value


Recommended Posts

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

Link to comment
Share on other sites

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,

Link to comment
Share on other sites

  • 4 years later...

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>

 

Link to comment
Share on other sites

  • 6 months later...

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!

Link to comment
Share on other sites

  • 4 months later...

 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>

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...