how can i make a live hyperlink in domo off of a record id?

Reply
Yellow Belt

how can i make a live hyperlink in domo off of a record id?

is there simple mysql code to concat an html string and then create a live hyperlink? when i try in beast mode it creates a drill down instead of going to the intended website.

 

thanks for your help!


Accepted Solutions
Yellow Belt

Re: how can i make a live hyperlink in domo off of a record id?

It works as a beast mode field but you have to get your quotes correct. I ran into the same issue a few times.

 

CONCAT('<a href="https://MyURL/Example?Id="', `ID Column`, '&SecondPartofURL" target="_blank">', `Name Column`, '</a>')

 

Assuming your `ID Column` for a record is 5555 and the `Name Column` contains 'XYZ Record' the link would say 'XYZ Record' and would open https://MyURL/Example?Id=5555&SecondPartofURL in a new browser window.

 

View solution in original post


All Replies
Yellow Belt

Re: how can i make a live hyperlink in domo off of a record id?

It works as a beast mode field but you have to get your quotes correct. I ran into the same issue a few times.

 

CONCAT('<a href="https://MyURL/Example?Id="', `ID Column`, '&SecondPartofURL" target="_blank">', `Name Column`, '</a>')

 

Assuming your `ID Column` for a record is 5555 and the `Name Column` contains 'XYZ Record' the link would say 'XYZ Record' and would open https://MyURL/Example?Id=5555&SecondPartofURL in a new browser window.

 

View solution in original post

Yellow Belt

Re: how can i make a live hyperlink in domo off of a record id?

had to tinker around a bit to get

 

CONCAT('<a href=', CONCAT('https://URL/',`ID`), '>',`ID`, '</a>')

 

but otherwise it worked--thank you very much for your help!!

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!