Text/Font color using HTML/Beast Mode for Table Card
I am color coding a Table card using HTML in beast mode. I can change the background color, but unable to change the text/font color.
(CASE
-- light red
when `2017-09-01` < `5 Yr Avg` and `2017-09-01` > `2017-08-01`
then CONCAT('<div style="color:#000000; background-color:#fcbcb7; color:black; text-align: right; text-decoration:none; width: 100%; height:100%; margin:-20px; padding:20px;"><a href="#">',ROUND(`2017-09-01`, 2), '</a></div>')
END)
If I add color:#000000, it has no impact. The default text color is blue and does not look good for some of the background colors I'm choosing.
Comments
-
0
-
-
Try something like this:
CONCAT('<a href="https://...', '" target="_blank"><font color="black">', `Object Name`, '</font></a>')
Of course you can replace "black" with whatever color you like.
0 -
Here is a working example of applying custom background and font color to a table cell. In this case, if sales amount total is <300K then it's red background with white font, otherwise green background with white font.
CASE
WHEN SUM(`Sales Amount`) < 300000 THEN
concat('<div style="background-color:red; color:white; margin:-20px; padding:20px">',SUM(`Sales Amount`),'</div>')
ELSE
concat('<div style="background-color:green; color:white; margin:-20px; padding:20px">',SUM(`Sales Amount`),'</div>')
ENDJacob Folsom
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 87 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 117 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive