Forum Discussion

RonMcLemore's avatar
RonMcLemore
Qrew Member
6 years ago

Color coding a field rather than the entire record in a report.

I have a date field [Date_Action1_Complete]  and a text field [Action1_Description}. When the action is completed, the user enters the date completed in the [Date_Action1_Complete] field. There may be 20 or 30 of these data-action field pairs.

 

I am trying to create a report that highlights those date fields that are null so they are easy to identify. For example, if [Date_Action1_Complete] is empty, the [Date_Action1_Complete] field will have a yellow background color.

 

Thanks in advance,

 

Ron McLemore

 

Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    I presume that you are aware that you can have form rules to make the date field required if action has been entered ( and vice versa).

    I don't believe that here us a native way to highlight cells like that on a report.  I think your best option would be to create 20 icons to flag pairs which need attention. 

    Handy icons are here
    https://login.quickbase.com/db/bcgnn27bx?a=q&qid=1000039

    For example,
    IF(trim([acton 1])<>"" and IsNull([date 1]),
    "<img src=
    https://images.quickbase.com/si/16/204-warning.png>")


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
  • Ed_AMathias's avatar
    Ed_AMathias
    Qrew Member
    6 years ago
    I have done this by creating a rich text formula field.  I created a new field "Billable..."  I have the field "Billable".  This has a value of Yes or No.  If yes I want the color to be green, if no red.

    This is the formula I am using

    Case([Billable], "Yes", "<div style=\"color:white; background-color:#27AE60;\"> Yes</div>",
    "No","<div style=\"background-color:#FF6666;\">No</div>",
    "Medium", "<div style=\"background-color:#FF9999;\"> Medium</div>",
    "Low","<div style=\"background-color:#FFCCCC;\"> Low</div>", "")

    ------------------------------
    Ed A Mathias
    VP of OPS
    Athena Technology Solutions
    Fremont CA
    ------------------------------