Add multiple Hyperlinks in one cell

leeloo_dallas · October 2021

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.

MarkSnodgrass · October 2021

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>')

MichelleH · October 2021

@leeloo_dallas Can you show an example of what you want the output to look like?

jaeW_at_Onyx · October 2021

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.

leeloo_dallas · October 2021

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.

AndreMoraes · July 2023

That worked for me, thank you!

Answers