Conditional Formatting on a Date in a Card Table
I have a date formatted column in a Card using a Table that I would like to apply a gray shade to the cells when the date is missing. I see other DOMO discussions where HTML Table was recommended and to use HTML in the Beast Mode however I'm not having luck.
Best Answer
-
This worked:
case when replace(
Date
,'00:00:00','')
like '%-%' Then replace(Date
,'00:00:00','')
else 'No Date' EndApplied Color Rule on the Beast Mode above on No Date and was able to highlight my missing date cells. The nulls have "No Date" vs a blank however should not be a problem for my scenario.
0
Answers
-
@ssheffer77 Can you share the beast mode that you tried?
0 -
Have you tried utilizing color rules and making the condition where isn't blank to apply to the cell and not the entire row?
You may need to use a beast mode to set a default as it may not show empty value as an option.
COALESCE(`Date Column`, 'MISSING DATE')
Then set color rules based on the beast mode where the value is MISSING DATE
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@MichelleH I tried the below with attempt to apply a Color Rule on "No Dates" however the condition wants to still have date logic used.
CASE WHEN ifnull(
Date Proposal Sent
,0)=0 THEN 'No Date' ElseDate Proposal Sent
EndTrying to play around with this one but no luck either (I would still need to add correct color to the below).
CASE
WHEN ifnull(`Date Proposal Sent`,0)=0 THEN CONCAT('<div style="background-color:#bbe491; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">', `Date Proposal Sent`, '</a></div>')
WHEN `Date Proposal Sent` < "01/01/1900" THEN CONCAT('<div style="background-color:#fcbcb7; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">', `Date Proposal Sent`, '</a></div>')
END
0 -
@GrantSmith I tired different beast mode functions with the color rules and so far each attempt is not allowing a condition on "missing date" but still working on this one to see if anything will work.
0 -
This worked:
case when replace(
Date
,'00:00:00','')
like '%-%' Then replace(Date
,'00:00:00','')
else 'No Date' EndApplied Color Rule on the Beast Mode above on No Date and was able to highlight my missing date cells. The nulls have "No Date" vs a blank however should not be a problem for my scenario.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive