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
-
Hiu @suwandy you have to include the <div> tag like this, I also attached a photo of what it showed.
CONCAT('<div style="">', -- Combine data and format
'✅',' Hello ', COUNT(`IMPL_DT`),
'</div>' -- end format
)**If this answer solved your problem be sure to like it and accept it as a solution!
0 -
Here is a knowledge base article with some other examples.
**If this answer solved your problem be sure to like it and accept it as a solution!
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.
**If this answer solved your problem be sure to like it and accept it as a solution!
1 -
To get the links I just searched up the emoji and then right clicked on an image and selected copy image address
**If this answer solved your problem be sure to like it and accept it as a solution!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 712 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive