Hyperlink

qzqzqzqzqz
qzqzqzqzqz Member
in Cards, Dashboards, Stories

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!

Best Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    edited October 2023 Answer ✓

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

    **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.
  • ColemenWilson
    ColemenWilson Coach
    edited October 2023 Answer ✓

    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.

    If I solved your problem, please select "yes" above

Answers

  • ColemenWilson
    ColemenWilson Coach
    edited October 2023

    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.

    If I solved your problem, please select "yes" above

  • pauljames
    pauljames Contributor

    I just answered earlier today :)

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

    IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

  • qzqzqzqzqz
    qzqzqzqzqz Member

    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?

    image.png

    thanks again!

  • MarkSnodgrass
    MarkSnodgrass Coach
    edited October 2023 Answer ✓

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

    **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.
  • ColemenWilson
    ColemenWilson Coach
    edited October 2023 Answer ✓

    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.

    If I solved your problem, please select "yes" above

  • qzqzqzqzqz
    qzqzqzqzqz Member

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

    image.png

Categories