Discussions

 View Only
  • 1.  Summary Report and Color Coding or Rich Text Formula Field

    Posted 01-26-2021 13:25
    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
    ------------------------------


  • 2.  RE: Summary Report and Color Coding or Rich Text Formula Field

    Posted 01-26-2021 13:26
    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
    ------------------------------



  • 3.  RE: Summary Report and Color Coding or Rich Text Formula Field

    Posted 07-27-2022 09:20
    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
    ------------------------------