Add multiple Hyperlinks in one cell

Options
leeloo_dallas
leeloo_dallas Member
in Charting

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 Coach
    Options

    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:

    image.png 
    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 <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • MichelleH
    MichelleH Coach
    Options

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

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach
    Options

    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"
  • leeloo_dallas
    leeloo_dallas Member
    Options

    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.

  • AndreMoraes
    AndreMoraes Member
    Options
    https://community-forums.domo.com/main/discussion/comment/55256#Comment_55256

    That worked for me, thank you!

Categories