Skip to main content
Question

Color Coding Blank Dates

  • August 3, 2021
  • 0 replies
  • 52 views
Hello. 

I don't know if this is possible but I have tried several formulas to no avail. I am trying to assign a color to show if a field has a blank date in a report. like this:


------------------------------
Jessica Stevens
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+17
  • EvanMartinez
  • Community Moderator
  • August 5, 2021
Hi Jessica,

In order to color code individual fields like your example for reporting it actually takes two fields. One would be holding your dates and that data as they do today and the other field would be a formula rich text field that is set up to read those fields and apply styling to them. It is a technique used a lot in building reporting and forms to highlight numbers of interest, etc. Alternatively, you can use report formulas to highlight an entire record if a date field or date fields are blank but it will highlight the entire row not just that individual field. 

A really simple example I have in one of my apps of a formula like this would be something like:

If(IsNull([Date]), "<span style=\"background-color:#76EEC6;\">" & "Not Scheduled" & "</span>", ToText([Date]))

This is just meant to display a colorized warning message when a field hasn't been entered in, you can get more or less fancy on your reports to catch the eye. Plus I'm sure there are others on the community that have built their own styling formulas. There is also a really handy application that can help with building these kind of formulas you can find here: The Automation Formula Machine

------------------------------
Evan Martinez
Community Marketing Manager
Quickbase
------------------------------
Terms & ConditionsAccessibility statement