Hello, I have a summary report shown below, 1 of 9 that I'm building. Each of these summary reports takes a particular set of Statuses and totals them. Each total OR column headers will need to be colorized (red, yellow or green) and placed on our Homepage Dash. These status totals are not related to any dates or timelines. They are used for showing the total $ amount of insurance policies that were entered for the previous month, current month and next month by status. For example, the report above shows policies from the previous month. It would be amazing if I could make the Status and Annual TP column header red, given these totals represent policies that were Declined, Surrendered, Withdrawn etc. My next report would then be colorized yellow for policies that have a different set of statuses, then green column headers for policies for example that have been paid. Hope this makes sense! I'm open to any suggestions. Thanks for any help!

Thank you, Mark. This worked very well!------------------------------Niraj Shah------------------------------

Sorry, but I can't really help with that code.I do have some code from Kirk Trachey magic buttons app. var text redbox = "https://i.imgur.com/yJEyaf7.png"; // red var text yellowbox = "https://i.imgur.com/5DhaU3e.png"; // yellowvar text greenbox = "https://i.imgur.com/gR9BVs6.png"; // greenvar text graybox = "https://i.imgur.com/h3f203O.jpg"; // grayvar text orangebox = "https://i.imgur.com/ogUnxiE.png"; // orangevar text box = If([Performance]<0.6,$greenbox, If([Performance]<0.9,$yellowbox,$redbox));var text widthval ="\"" &Min(Max([Performance]*200,0),200)&"\"";var text widthvalbalance ="\"" &ToText(Max(0,Min(200,200-([Performance]*200))))&"\"";"<div style='position:relative;color:white;'>" & "<div style=\"width: 200px; \"><img height = 18 width="&$widthval & "src=\""&$box&"\" title='Performance: " & Round([Performance]*100) & "%' />" &"<img height = 18 width="&$widthvalbalance&"src=\""&$graybox&"\" title='Remaining: " & Round((1-[Performance])*100) & "%'/></div>"& "<div style='position:absolute;top:2px;left:2px;'>"&Round(([Performance])*100)&"%</div>"& "<div style='position:absolute;top:2px;left:171px;'>"&Round((1-[Performance])*100)&"%</div>"// TO REMOVE THE DISPLAYED NUMBERS SIMPLY PUT // INFRONT OF LINE 11 AND 12 ABOVE// This is referencing a [Performance] formula field that is measuring "Performance" against an "SLA Max".// There are 2500 other graphics available for your QuickBase application at: https://www.quickbase.com/db/9kaw8phg?a=ShowPage&pageid=134. This bar changes color when a threshold has been met.// This formula was built upon the original code of Sam Jones and subsequent refinements by Avinash Sikenpore

You can use any Formula Rich text fields as row and column headers.

I'm intrigued! How would you do this? We are not talking about row colorization or even field colorization here, right? How would you color the actual header in a report as opposed to the field or row being populated in the report?

I think this is what you want and you can do it with the script shown below:$("td[id=anchorCell]:eq(0)").nextAll().andSelf().css({backgroundColor: "red"})$("td[id=anchorCell]:eq(1)").nextAll().andSelf().css({backgroundColor: "blue"})$("td[id=anchorCell]:eq(2)").nextAll().andSelf().css({backgroundColor: "green"})

Total Field or Column Header Colorization in a Summary Report

18 Replies

arovney
Qrew Member
6 days ago
I know this is a really old post lol but it worked for changing the background color on my home page for reports. I'm trying to figure out how to change the font color too but I'm not sure how. I haven't been able to find any resources to help me understand the code that posted above. I actually couldn't find any other help articles at all on this.
Any ideas?
- MarkShnier__You
  Qrew Legend
  6 days ago
  It is not clear what you are asking here. You seem to be saying that you managed to change the background shading, but cannot understand how to change the font color. We would need to know what report type you are using (Table or Summary Report?), and see a screen shot of what you gave so far and what your current formula is that is partially workring.
  - arovney
    Qrew Member
    5 days ago
    Hi, Thanks!
    You have it right. Here is a little more info:
    They aren't summary reports but they are full reports filtered to the user. The reports are displayed on a homepage. I attached the screenshot.
    I tried to include other CSS elements in the same script on the code page I created. When that didn't work I created a second code page and just started playing around with the CSS color. Here is what I have right now for font color:
    There are quotes around red on the last two. I've tried this with quotes on all, without quotes on all and then just the below to see if the first table would change. I've also tried the hexcode
    <script>
    var $ = window.parent.$;
    $(function () {
    $("td[id=anchorCell]:eq(0)").nextAll().andSelf().css({color: red});
    $("td[id=anchorCell]:eq(1)").nextAll().andSelf().css({color: "red"});
    $("td[id=anchorCell]:eq(2)").nextAll().andSelf().css({color: "red"});
    });
    </script>
    I don't know the language used above. I think it's javascript but I'm not sure. I'll launch into learning it once I understand what I'm doing wrong and where to start learning.
    Here is the screenshot
    The colors aren't important, I can play with those later. I'm just trying to figure out how to change the font color so I get something I can use with the background.
    Thanks for helping

Forum Discussion

Total Field or Column Header Colorization in a Summary Report