Colour condition for words in a string
Hi Folks,
Does anyone know how to create a beastmode that colour conditions each word in a string within a single cell for a table visual?
For example:
These values have to remain joined by the '/' delimiter so I won't simply separate them into columns.
All responses appreciated
Kind regards,
Answers
-
You could utilize an HTML table and utilize HTML code to colorize each value in your string. You'd need to CONCAT the HTML code together with your values and conditionally set the color. I've done a previous writeup on this here: https://dojo.domo.com/main/discussion/52684/domo-ideas-conference-beast-modes-conditional-formatting#latest
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
You could also utilize a regular expression to modify your string and automatically insert the HTML code.
Something like this might work assuming your values are actual colors (untested)
REGEXP_REPLACE(`RAG History`, '.*((Yellow)|(Red)|(Green)).*', '<div><span style="color: $1">$1</span></div>')
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
@GrantSmith Thanks I'll give it a try and update this thread.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive