Forum Discussion

JoeGoodhart's avatar
JoeGoodhart
Qrew Member
5 years ago

Summary Report and Color Coding or Rich Text Formula Field

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
------------------------------
Formulas and functions
  • RyanMurray's avatar
    RyanMurray
    Quickbase Staff
    3 years ago
    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
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    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
    ------------------------------