Adding Hyperlink to table values
Hey all,
Does anybody have any experience writing a beast mode formula to insert a hyperlink into a table value within Domo? Can't seem to get it right.
Thanks in advance!
Best Answer
-
Set your beast mode formula like so:
CONCAT('<a href="', `Link`, '" target="_blank">', `Title`, '</a>')
Let me know if you have any questions.
11
Answers
-
Set your beast mode formula like so:
CONCAT('<a href="', `Link`, '" target="_blank">', `Title`, '</a>')
Let me know if you have any questions.
11 -
Thanks! I was able to get the hyperlink value to be clickable, but the link takes me to a page within domo, not to the external link.
It's basically taking me to a blank page that has the same url as my original domo page with the url i'm trying to link to at the end
0 -
Never mind just figured it out, just needed to add the https:// in front. Thanks for your help!
2 -
Could you please describe in greater detail, as to what values go where and why?
Unsure what `Link` and `Title` refer to, and, if the ` is necessary. Example data:
A four-cell table. Headers: NAME and COLOR. Values: BOB and BLUE.
And I'd like BLUE to be a link to this page: https://en.wikipedia.org/wiki/Blue
Appreciate your help!
0 -
`Link` and `Title` refer to the columns in the data with the symbols being the column identifiers. Like `NAME` or `COLOR`. All beast mode column references require the symbols.
Example:
CONCAT('<a href="', 'https://en.wikipedia.org/wiki/Blue', `Name`, '</a>')
The name Bob will show up with the underlying link to the Blue wiki article.
You could put a case statement in there to insert the color value into the web link, given the web page is the name from the data.
Aaron
MajorDomo @ Merit Medical
**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"2 -
Hello,
I am in a very similar situation, but I have a column that already contains the URL. As of now, the URL is not clickable, so I need to make Domo recognize it as a hyperlink that can be clicked on. So I have a column named 'Link' which contains each row's URL. How can I use this column with Beast Mode to make these URL's become clickable hyperlinks? All i need is the raw URL to be clickable. I don't really need the URL to be a hyperlink with a name. Thank you in advance!
Here is what I tried, which led to a new column named 'URL', but no links were populated: CONCAT('<a href="', `Link`, '" target="_blank">', '</a>')
0 -
Try something like this:
CONCAT('<a href="',`Link`,'">',`Link`,'</a>')
Aaron
MajorDomo @ Merit Medical
**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"5 -
Brilliant! Thank you! So very helpful!
0 -
Does anyone know if this beast mode works in the Mega Table card? I'm having issues with it.
0 -
king
0 -
I have been able to succesfully do this in a Mega Table.
0 -
Hello! thank you! Very helpful.
One question, do you know if there is a way to make the link open a new window, right now I have the link in megatable but if I click on it the link is opening in the same page, and is a little annoying to go back to domo all the time.
Lilia
0 -
@LiliRestrepo adding the target="_blank" argument in the HTML code should do this for you.
It would look like this:
CONCAT('<div><a href="', 'https://yourinstance.domo.com/datasources/', `Dataset ID`, '/details/overview', '"', '"target="_blank">', `Name`, '</a></div>')
^^This is one I use in our instance to provide a clickable link on dataset names.
4 -
@mhouston that worked! thank you so much!!!
1 -
I could generate the link, but still when I click that link, the webpage is not opening... Its working as Interaction only... Please help
0 -
@Jigar_Thakkar What interaction settings to you have configured for that card in the dashboard?
1 -
Hi, MechelleH, Thanks for help, but I found the exact issue, the issue was that my link was not starting with "Https//" - I chnaged it and the issue was solved.
Thanks a lot to community for great help. Let me share what all important points need to take care whole doing this.
- The link in the column should start with "Https://"
- In formula the "Link" is the field name of the column in which the links are there - CONCAT('<a href="', `
Field name of the column
`, '" target="_blank">', '</a>')
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 99 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 728 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive