Hyperlink

qzqzqzqzqz

Hi,

I created a Mega table and one of the columns is an URL. I would like the user to be able to click on the URL then automatically open a new tab and land on the page. I can do this in Tableau and I wonder if I could do this with Domo?

Thanks!

MarkSnodgrass

This how you would construct it to make the URL dynamic by Opportunity ID

CONCAT('<div><a href="https://xyz.lightning.force.com/lightning/r/Opportunity/','`Opportunity ID`','/view', '" "target="_blank">',`Opportunity ID`, '</a></div>')

ColemenWilson

Gotcha! @MarkSnodgrass code should work. Although, I use a slightly different beastmode at my organization:

CONCAT('<div><a href="https://xyz.lightning.force.com/lightning/r/Opportunity/', Opportunity.Id, '"', '"target="_blank">', Opportunity.Name, '</a></div>')

If this doesn't work for you please let me know.

ColemenWilson

Yep! You can. Here is the beastmode:

CONCAT('<div><a href="',`Link`,'"', '"target="_blank">',`Link`, '</a></div>')

You can also replace the 2nd occurence of `Link` in the beastmode with any other field to display that in the table instead of the link.

pauljames

I just answered earlier today :)

https://community-forums.domo.com/main/discussion/62274/how-to-add-hyperlink-in-the-table

qzqzqzqzqz

thank you both! I tried but the link does not work. I must have missed something.

The original URL is:

https://xyz.lightning.force.com/lightning/r/Opportunity/ABCDE/view

What I would like to do is to make 'ABCDE' a variable. It is called 'Opportunity ID' in my dataset. I created the following beast mode but the link was incorrect. Could you please advise what I did incorrectly?

thanks again!

MarkSnodgrass

This how you would construct it to make the URL dynamic by Opportunity ID

CONCAT('<div><a href="https://xyz.lightning.force.com/lightning/r/Opportunity/','`Opportunity ID`','/view', '" "target="_blank">',`Opportunity ID`, '</a></div>')

ColemenWilson

Gotcha! @MarkSnodgrass code should work. Although, I use a slightly different beastmode at my organization:

CONCAT('<div><a href="https://xyz.lightning.force.com/lightning/r/Opportunity/', Opportunity.Id, '"', '"target="_blank">', Opportunity.Name, '</a></div>')

If this doesn't work for you please let me know.

qzqzqzqzqz

thank you both for your quick responses! I leveraged both of your advises and below is what I used eventually: