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
-
-
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
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 965 Connectors
- 254 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 75 SQL DataFlows
- 498 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.1K Charting
- 357 Beast Mode
- 19 Variables
- 481 Automate
- 101 Apps
- 376 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 57 Manage
- 57 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 36 Getting Started
- 22 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive