This article explains how to apply custom background and font colors conditionally based on the values in a report.

Steps to apply custom background and font colors:

In this example, we applied different colors and backgrounds to the letter grade column.

  1. Edit your report DataPages (i.e., Tabular, List or Gallery)
  2. Proceed to the Configure Results Page section.
  3. Add an HTML block.
  4. Disable the HTML Editor.
  5. Enter a label name in the Label section of the HTML block, i.e., Letter Grade.
  6. Copy and paste the following JavaScript in the HTML block.
  7. Replace [@field:ID#] with the unique field from your table or a view used as a data source. Add this field from the insert picker to avoid syntax errors.
  8. Add conditions relevant to your use case within the if(…) block.
  9. Save the DataPage.

Note: This article uses external HTML, JavaScript, or third-party solutions to add functionality outside of Caspio standard feature set. These solutions are provided “as is” without warranty, support or guarantee. The code within this article is provided as a sample to assist you in the customization of your web applications. You may need a basic understanding of HTML and JavaScript to implement successfully.

code1
<span id="[@field:ID#]changeColor1" style="color:#008000"></span>
<span id="[@field:ID#]changeColor2" style="color:#0000FF"></span>
<span id="[@field:ID#]changeColor3" style="color:white; background:red"></span>

<script>
if([@field:GPA#]>=3.5 && [@field:GPA#]<=4.0 )
{
document.getElementById('[@field:ID#]changeColor1').innerHTML='A';
}
else if([@field:GPA#]>=3.0 && [@field:GPA#] <3.5)
{
document.getElementById("[@field:ID#]changeColor2").innerHTML='B';
}
else if([@field:GPA#]>=2.5 && [@field:GPA#]<3.0 )
{
document.getElementById("[@field:ID#]changeColor3").innerHTML='C';
}
</script>