Add multiple Hyperlinks in one cell

leeloo_dallas

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

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

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

jaeW_at_Onyx

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

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.