How do I replace text with unicode
Hello,
I'm trying to replace some characters in my table using Unicode Characters such as :white_heavy_check_mark: and with :cross_mark:
This is the code I typed into the Beast Mode but it's not displaying it and instead only showed the literal '✅', could anyone please help?
Case when `Last Week Actual` - `Last Week Target` >= -9999 then
'✅'
when `Last Week Actual` - `Last Week Target` >= 0.001 then
'❌'
else '' End
Thanks in advance.
Comments
-
Here is a knowledge base article with some other examples.
0 -
Hello there,
Thanks for your response. I tried it however it only gave me this result instead (see attachment)
This is the new code I used.
Case when `Last Week Actual` - `Last Week Target` >= -9999 then
CONCAT('<div style="">', '✅', ' Hello ', '</div>' )
when `Last Week Actual` - `Last Week Target` >= 0.001 then
CONCAT('<div style="">', '✅', ' Hello ', '</div>' )
else '' EndBy the way, I couldn't see the photo you attached. Could you attach it again please?
0 -
@suwandy To see the image you have to download, for some reason they do not show just by clicking on it (could be computer security settings). I did not realize you were trying to get it in a table; the code I provided was for a summary number. I think to put it in a table you will want to use an image rather than the Unicode. In the link I provided in my last message, there is a section for how to add images to a table. I went ahead and did an example. Here is my code:
Case
when `Entered Hours` > 0 then CONCAT('<div style="text-align:center"><img alt="UP" height="20px" src="https://s3.amazonaws.com/pix.iemoji.com/images/emoji/apple/ios-12/256/white-heavy-check-mark.png">','</div>')when `Entered Hours` <=0 then CONCAT('<div style="text-align:center"><img alt="UP" height="20px" src="https://banner2.kisspng.com/20180715/klo/kisspng-check-mark-emojipedia-computer-icons-symbol-cek-5b4bdef7a0b662.6919404015316989356583.jpg">','</div>')
else ''
End
Download the image to see what it made.
1 -
To get the links I just searched up the emoji and then right clicked on an image and selected copy image address
0
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive