Skip to main content
Question

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

  • January 13, 2020
  • 0 replies
  • 55 views

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

 

This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
  • EdAMathias
  • Registered
  • January 13, 2020
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
------------------------------
Terms & ConditionsAccessibility statement