Skip to main content
Question

Summary Report and Color Coding or Rich Text Formula Field

  • January 26, 2021
  • 0 replies
  • 227 views
I've read that color coding is not available in 'summary reports'.   Is this still true?

Is there another way to display a 'red yellow green' status by row on a summary report?  For example:

Column 1 =  Year to Date Actual Values
Column 2 = Year to Date Expected Values

If column 2 > column 1, then "<img src=\"https://images.quickbase.com/si/16/221-point_red.png\"
If column 2 < column 1, then "<img src=\"https://images.quickbase.com/si/16/222-point_green.png\"

------------------------------
JG999
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
At present, there is not a way to do calculations between columns on a summary report.  But I do recall a recent article that his is on the near term roadmap as a new feature planned to come out.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+4
  • RyanMurray
  • Quickbase Staff
  • July 27, 2022
Hi Joe,

We don't have any immediate plans to implement colorization in summary reports, but you can achieve a similar effect by using a Summary Formula and a Rich Text field. Here's an example:

var text red = "<a style=\" text-decoration: none; background: #ea4335; border-radius: 5px; color: #fff; display: inline-block; width: 80px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">"&[number of issues] & "</a>";

var text green = "<a style=\" text-decoration: none; background: #34a853; border-radius: 5px; color: #fff; display: inline-block; width: 80px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">"&[number of issues]&"</a>";

var text yellow = "<a style=\" text-decoration: none; background: #fbbc05; border-radius: 5px; color: #fff; display: inline-block; width: 80px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">"&[number of issues]&"</a>";

var text gray = "<a style=\" text-decoration: none; background: #c2c2c2; border-radius: 5px; color: #fff; display: inline-block; width: 80px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">"&[NUMBER OF ISSUES]&"</a>";

If([number of issues]=0,$gray,
(If([number of issues]<25,$green,
(If([number of issues]<=30,$yellow,$red)))))

And here's the output
If you have any trouble setting it up, feel free to reach out to our Tech Support team.

Ryan


------------------------------
Ryan Murray
------------------------------
    Terms & ConditionsAccessibility statement