Add multiple Hyperlinks in one cell
Hey there,
I have been trying to create a hyperlink in my cell using Domo Beastmode.
The issue is, if there is a string proceeding or following the link, the entire cell becomes a link.
Which is problematic because some cells are have multiple links with string while others have multiple links and no string.
Is there a way to hyperlink a value using DOMO Beastmode without turning my entire cell into a hyperlink?
I wish I could search the entire column for links and then turn it into a hyperlink, but I don't think that's possible in beastmode.
I've performed the following:
(CASE
WHEN `Significant Digital Projects` LIKE '%https://bit.ly/3vHrQoy%' THEN CONCAT(CONCAT('INSERT STRING EXAMPLE:'), CONCAT('<div><a href="https://bit.ly/3vHrQoy"','"target="_blank">','https://bit.ly/3vHrQoy','</a></div>'))
ELSE `Significant Digital Projects`
END)
I've tried wrapping my string in a separate concatenate and then joining, but that didn't work.
Can anyone help? I want to do this in only beastmode. Not magic etl.
Answers
-
Make sure you are using the HTML table card. In your beast mode, you can use one CONCAT function and have as many links as you want. Example:
CONCAT('<a href=https://www.google.com>Google</a>',' ','<a href=https://www.yahoo.com>Yahoo</a>')
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
@leeloo_dallas Can you show an example of what you want the output to look like?
0 -
think like a web dev. assume your table card must contain a div tag.
<div> text content <a href> ... </a> </div>
so now just concat in your CASE statement inside the DIV tag.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Hey @jaeW_at_Onyx
Thanks for the info.
I generated a Domo ticket and discovered it's not possible at the moment to separate hyperlinks from texts or have multiple, in cell.
I submitted a suggestion though, so hopefully in the future it'll be possible.
1 -
That worked for me, thank you!
1
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 704 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive