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

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟤

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


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

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    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.

  • 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.