Creating a Link Field in Domo

Reply
Highlighted
Yellow Belt

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!

Highlighted
Green Belt

Re: Creating a Link Field in Domo

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

Highlighted
Orange Belt

Re: Creating a Link Field in Domo

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

 

 

Highlighted
Yellow Belt

Re: Creating a Link Field in Domo

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>'
Highlighted
Black Belt

Re: Creating a Link Field in Domo

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



**Make sure to like any users posts that helped you and accept the ones who solved your issue.**
Highlighted
Blue Belt

Re: Creating a Link Field in Domo

@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 the heart icon**

**Did this solve your problem? Accept it as a solution!**
Announcements
Want to join our weekly online meet up? Please visit this board here and let me know. Click here for more details!