Creating a Link Field in Domo

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!

Comments

  • 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

  • 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/'

     

     

  • 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 Portland, Oregon 🔵

    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')
  • GrantSmith
    GrantSmith Indiana 🟤

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

Sign In or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!