Forum Discussion
RyanMurray
3 years agoQuickbase Staff
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:
------------------------------
Ryan Murray
------------------------------
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
------------------------------
Ryan Murray
------------------------------