Create a dynamic hyperlink without having to put it in a table

Reply
Green Belt

Create a dynamic hyperlink without having to put it in a table

I want to insert a hyperlink in my page which changes based on the selection made in the filters available on my page. As of now, I can either insert a fixed hyperlink, or link something to a page within Domo. 

 

For now, I've created a column using beast mode which inserts a hyperlink in a number. The code is something like this: 

 

(CASE
WHEN `platform` = 'X' THEN CONCAT('<div style="text-align: center"><a href="https://',`xx`,'/xxx/',`xxxx`,'"target="_blank">',`xxx`,'</a></div>')
END )

 

But I have to use this in a table. Is there anyway I can insert a dynamic hyperlink in a dashboard without doing such a calculation in beast mode. 

Black Belt

Re: Create a dynamic hyperlink without having to put it in a table

You can also use HTML code in summary numbers.  You can use that to create the link as well


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________
Green Belt

Re: Create a dynamic hyperlink without having to put it in a table

That does not work. We tried it. 

Green Belt

Re: Create a dynamic hyperlink without having to put it in a table

In summary, we're given the option of 'count' or 'sum' (depending on the column type). 

 

There's not a way we can show the hyperlink

Black Belt

Re: Create a dynamic hyperlink without having to put it in a table

The summary number does have to be an aggregate function.  

 

Maybe I just need some more details about what you are trying to create a link to, and how you want that to work.  

 

I've created links using something like this in the past:

max(concat('<a href="'
,'https://your_url.my.salesforce.com/',`Salesforce Account ID`,
'" target="_blank">'
,'<img src="your_image_link" width="50" height="25">',
'</a>'))

Give me a link like this:

2019-11-20_14-47-32.png


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________
Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!