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

hamza_123
hamza_123 Contributor
in Charting

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. 

Comments

  • ST_Superman
    ST_Superman Domo Employee

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

  • hamza_123
    hamza_123 Contributor

    That does not work. We tried it. 

  • hamza_123
    hamza_123 Contributor

    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

  • ST_Superman
    ST_Superman Domo Employee

    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

This discussion has been closed.

Categories