Creating a Link Field in Domo

mamedu
mamedu Member
in Magic ETL

Hi All, 

 

I was trying to have a hyperlink embedded inside a Domo Table/MegaTable and I used the following method. 

 

CONCAT('<a href="https://na132.salesforce.com/', `donation_link`, '" target="_blank">', 'Donation Link', '</a>')

 

Now this is working perfectly on Domo but one major problem I'm facing is when I export the data, the column in a excel/csv file is coming out as 

 

<a href="https://na132.salesforce.com/" target="_blank">Click to View</a>

 

Is there a way around this? My users need to be able to export the hypelink out of Domo and I can't seem to find any way to do this. 

 

Thanks to everyone for helping!

Tagged:

Comments

  • Neeti
    Neeti Member

    Hi @mamedu ,

     

    I have never tried this, just thinking if you could do substr to only get the required string from the column?

    Will this work?

     

    **Say "Thanks" by clicking the "heart" in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

     

    Thanks,

    Neeti

  • MichelleH
    MichelleH Coach

    I've encountered the same thing, although I'm curious about your use case for needing the export the links. The HTML hyperlink embed is best suited for if the users need to navigate to a site directly out of Domo. 

     

    If the export functionality is neccesary, I would suggest removing the HTML and only showing the URL. So your beast mode would change from this:

    CONCAT('<a href="https://na132.salesforce.com/', `donation_link`, '" target="_blank">', 'Donation Link', '</a>')

    To this:

    'https://na132.salesforce.com/'

     

     

  • mamedu
    mamedu Member

    The thing is there's a field associated that populates the key for the link per each row. How will I show that?

     

    Ex:

    'https://na132.salesforce.com/<field_ID>'
  • MarkSnodgrass
    MarkSnodgrass Coach

    You would still make use of the CONCAT function. It would just look like this to incorporate the field_ID. 

    CONCAT('https://na132.salesforce.com/','field_ID')
    **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.
  • GrantSmith
    GrantSmith Coach

    @mamedu 

     

    I've typically just had two separate fields as part of my dataset. One which has the HTML code to make the link clickable and another with just the URL like @MarkSnodgrass suggested. You do have some data duplication but it gives the interactivity of a link within the page but then also allows the users to have just the URL in another field they can utilize in Excel whatever other application they're using.

     

     

    I've logged a new idea to allow us to format a field as a hyperlink (value is just a URL but allows user to navigate to the URL when clicking on it) under https://dojo.domo.com/t5/Ideas-Exchange/Format-As-Hyperlink/idi-p/47507 so if you think it'd be useful feel free to give it a thumbs up.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • tigers12
    tigers12 Member

    @GrantSmith

    Is it possible to use file:/ in the href? I am hoping to show a part picture for each item; however, the images I want are currently only stored on a network share drive.

    Thanks.

  • LiliRestrepo
    LiliRestrepo Contributor

    Hello! thank you! Very helpful.

    One question, do you know if there is a way to make the link open a new window, right now I have the link in megatable but if I click on it the link is opening in the same page, and is a little annoying to go back to domo all the time.

  • ST_-Superman-_
    ST_-Superman-_ Coach

    Hi @LiliRestrepo

    You have to add the target="_blank" tag

    CONCAT('<a href="https://na132.salesforce.com/', `field_ID`, '" target="_blank"></a>')



    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • LiliRestrepo
    LiliRestrepo Contributor

    Thank you @ST_-Superman-_ ! it worked 😁

Categories