Best Practice - Deep Linking - Excel Tool to Help you build deep links

swagner
swagner Contributor
edited March 2023 in Scheduled Reports

First, I want to thank @ST_-Superman-_ for helping me on this topic.  Outstanding detail provided!  THANKS!

 

If you're like me, not a techy, but would like to create page or card deep link beast modes maybe the attached Excel tool will help.  Please let me know if you have questions.  There is a link to a video included in the attached (of course).

 

cc:  @DaniBoy 

Best Answers

  • swagner
    swagner Contributor
    Answer ✓

    Here is the link to the video I created:

     

    https://www.youtube.com/watch?v=S9l56QtsUkc

    and the relevant Domo Knowledge Base article.

     

    Thanks!

  • ST_-Superman-_
    Answer ✓

    @swagner built this tool using power query, you might get some error messages if your version of excel does not support it.

     

    CONCAT('<a href=''https://superman.domo.com/page/########?pfilters=['
    -- Replace superman with your account name; ####### with target page id

    -- Page filters to pass to landing page
    ,'{"column":"field to filter","dataType":"string","operand":"IN","values":["'
    ,`field from table`
    ,'"]}'


    ,']'' target="_blank" title="Open in Domo">','display name for link','</a>'
    -- Replace 'display name for link' with what you want the link to say
    )

     

     

    Let me know if that helps.  You don't really need to use the excel tool if you can work your way through that SQL statement.

     

            _____________________________________________
    //:::::::::::::::::::::::::::::::::::::::::::::\
    //:::_______:::::::::________::::::::::_____:::::::\
    //:::_/ _-"":::_--""" """--_::::\_ ):::::::::\
    //:::/ /:::::_" "-_:::\/:::::|^\:::\
    //:::/ /~::::::I__ \:::::::::| \:::\
    \\:::\ (::::::::::""""---___________ "--------" /::://
    \\:::\ |::::::::::::::::::::::::::::""""==____ /::://
    \\:::"\/::::::::::::::::::::::::::::::::::::::\ /~::://
    \\:::::::::::::::::::::::::::::::::::::::::::)/~::://
    \\::::\""""""------_____::::::::::::::::::::::://
    \\:::"\ """""-----_____:::::://
    \\:::"\ __----__ )::://
    \\:::"\/~::::::::~\_ __/~:://
    \\::::::::::::::::""----""":::://
    \\::::::::::::::::::::::::://
    \\:::\^""--._.--""^/::://
    \\::"\ /":://
    \\::"\ /":://
    \\::"\_/":://
    \\::::://
    \\_//
    "

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

Answers

  • @swagner... Nicely done.  I'll be using this tool a lot.  Makes it much easier to create the deep links

     

    image

     

     

     


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • Love this collaboration, well done guys!

    THANK YOU!

  • swagner
    swagner Contributor
    Answer ✓

    Here is the link to the video I created:

     

    https://www.youtube.com/watch?v=S9l56QtsUkc

    and the relevant Domo Knowledge Base article.

     

    Thanks!

  • Hi, interesting stuff!  I'm struggling to understand the use case for this.   If I wanted to have a table card with links to another card with filters for category already applied, would I use this?  I downloaded the excel file, plugged in what I think are the appropriate values, and attempted to hit refresh all, but I get an error when doing so 'Initialization of the data source failed.'

  • ST_-Superman-_
    Answer ✓

    @swagner built this tool using power query, you might get some error messages if your version of excel does not support it.

     

    CONCAT('<a href=''https://superman.domo.com/page/########?pfilters=['
    -- Replace superman with your account name; ####### with target page id

    -- Page filters to pass to landing page
    ,'{"column":"field to filter","dataType":"string","operand":"IN","values":["'
    ,`field from table`
    ,'"]}'


    ,']'' target="_blank" title="Open in Domo">','display name for link','</a>'
    -- Replace 'display name for link' with what you want the link to say
    )

     

     

    Let me know if that helps.  You don't really need to use the excel tool if you can work your way through that SQL statement.

     

            _____________________________________________
    //:::::::::::::::::::::::::::::::::::::::::::::\
    //:::_______:::::::::________::::::::::_____:::::::\
    //:::_/ _-"":::_--""" """--_::::\_ ):::::::::\
    //:::/ /:::::_" "-_:::\/:::::|^\:::\
    //:::/ /~::::::I__ \:::::::::| \:::\
    \\:::\ (::::::::::""""---___________ "--------" /::://
    \\:::\ |::::::::::::::::::::::::::::""""==____ /::://
    \\:::"\/::::::::::::::::::::::::::::::::::::::\ /~::://
    \\:::::::::::::::::::::::::::::::::::::::::::)/~::://
    \\::::\""""""------_____::::::::::::::::::::::://
    \\:::"\ """""-----_____:::::://
    \\:::"\ __----__ )::://
    \\:::"\/~::::::::~\_ __/~:://
    \\::::::::::::::::""----""":::://
    \\::::::::::::::::::::::::://
    \\:::\^""--._.--""^/::://
    \\::"\ /":://
    \\::"\ /":://
    \\::"\_/":://
    \\::::://
    \\_//
    "

    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • A topic with 4 of my favorite Domoites doin' their thing...Just want to say 'Hi!'  

     

    I'll be passing this along to the folks I'm working with.  It looks like something that will make it simpler for folks to build in links.  

     

    Well Done!!!  @swagner @ST_-Superman-_ 

    Hello!  @JasonAltenburg @DaniBoy 

     

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
This discussion has been closed.