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

edited March 13 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
    Answer ✓

    Here is the link to the video I created:


    and the relevant Domo Knowledge Base article.



  • 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=''['
    -- 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


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






    “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!


  • 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.'

  • 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 


    Breaking Down Silos - Building Bridges
    Check out my video!
    **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"
This discussion has been closed.