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

swagner

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 

swagner

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-_

@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__                      \:::::::::|  \:::\
\\:::\   (::::::::::""""---___________     "--------"  /::://
 \\:::\  |::::::::::::::::::::::::::::""""==____      /::://
  \\:::"\/::::::::::::::::::::::::::::::::::::::\   /~::://
    \\:::::::::::::::::::::::::::::::::::::::::::)/~::://
      \\::::\""""""------_____::::::::::::::::::::::://
        \\:::"\               """""-----_____:::::://
          \\:::"\    __----__                )::://
            \\:::"\/~::::::::~\_         __/~:://
              \\::::::::::::::::""----""":::://
                \\::::::::::::::::::::::::://
                  \\:::\^""--._.--""^/::://
                    \\::"\         /":://
                      \\::"\     /":://
                        \\::"\_/":://
                          \\::::://
                            \\_//
                              "

ST_-Superman-_

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

 

 

 

 

[Deleted User]

Love this collaboration, well done guys!

THANK YOU!

swagner

Here is the link to the video I created:

 

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

and the relevant Domo Knowledge Base article.

 

Thanks!

JasonAltenburg

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-_

@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__                      \:::::::::|  \:::\
\\:::\   (::::::::::""""---___________     "--------"  /::://
 \\:::\  |::::::::::::::::::::::::::::""""==____      /::://
  \\:::"\/::::::::::::::::::::::::::::::::::::::\   /~::://
    \\:::::::::::::::::::::::::::::::::::::::::::)/~::://
      \\::::\""""""------_____::::::::::::::::::::::://
        \\:::"\               """""-----_____:::::://
          \\:::"\    __----__                )::://
            \\:::"\/~::::::::~\_         __/~:://
              \\::::::::::::::::""----""":::://
                \\::::::::::::::::::::::::://
                  \\:::\^""--._.--""^/::://
                    \\::"\         /":://
                      \\::"\     /":://
                        \\::"\_/":://
                          \\::::://
                            \\_//
                              "

DataMaven

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