Conditional Background Color Change

[senicholas]

I wish to have the field Dwell_Days background color change to yellow when the value exceeds 7 on my data page.

[Jan]

Hello senicholas,

 

It seems, that your question is a similar to this one.

Does it work for you?

[senicholas]

I saw your earlier discussion, but I cannot get the html block to equal the field Dwell_Day. How do you do that?

[casGary]

Hello Senicholas, 

Try to implement it this way:

<script>
function f_color(){
var myVal = parseInt(document.getElementById('ID').value);
if (myVal > 7) {
document.getElementById('ID').style.color = "red";
}
}
document.getElementById('ID').onchange= f_color;
</script>

[Jan]

Hi senicholas,

If you use a Report DataPage, I hope the following JavaScript can help:

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

The code checks all valaues and make the color "red", if the value is more than 7.

[senicholas]

How do you restrict it to one field. It works, but looks at all the numbers in the report. The field if F7

[Jan]

Hi senicholas,

 

It seems I have answered in another topic.

Is it the same question?

[vanderLeest]

Hi Jan

How can I compare two currency fields - set the Display Only on a Report Details Page -

and if the Invoiced value is higher than the Budget value,  color the  text of Invoiced  value red and its background yellow?

 

Thanks for your help

[cheonsa]

Hello! 

You can create a Calculated field and use Case When Formula to compare the fields. Then, apply a script in the Footer to highlight the column based on the result of the Calculated field.

To hide the Calculated field, you can use the code here:

 

[IamNatoyThatLovesYou]

Hello Everyone, just sharing this other solution that may help.