How to hyperlink values in a Mega Table
I have a dataset I am showing in a Mega Table, which contains URLs. I'd like to hyperlink the URLs so the user can click on them and go to the site. Is there a way to do this? I've been trying to following this suggestion: https://domohelp.domo.com/hc/en-us/articles/360043430033-Adding-Graphics-Links-and-Images-to-Table-Cards-Using-Beast-Mode - but it isn't working...
Thanks.
Best Answer
-
@User_32265 you're missing a " in your formua after src=.
Try this:
CONCAT('<div style="text-align:center"><img height="5px" src="',`Image # 1 Actual Content`,'">','</div>')
Also - 5 px is going to be really small, you probably need to increase that to be able to actually see the image.
1
Answers
-
To provide more information, I tried using this formula and it works:
CONCAT('<div><a href="https://www.google.com/"','"target="_blank">',`URL`,'</a></div>')
However, this just takes the user to google... how do I replace the "https://www.google.com/" with the URL link that is contained into the data, so the user goes to that specific site?
0 -
@User_32265 is the URL you are trying to send the user to in a field in the dataset? If so, you would just insert your field name instead of the url for google, like this:
CONCAT('<div><a href="',`URL`,'"','"target="_blank">',`URL`,'</a></div>')
assuming your field name in this case is URL.
4 -
YEs, that worked! Thank you!!!!
0 -
Now I'm trying to get images to load... I tried using this formula, but it isn't resulting in anything...
CONCAT('<div style="text-align:center"><img alt="DOWN" height="20px" src=`Image # 1 Actual Content`>','</div>')
I'm still going off this instructional page: https://domohelp.domo.com/hc/en-us/articles/360043430033-Adding-Graphics-Links-and-Images-to-Table-Cards-Using-Beast-Mode#h_9b0e3ed9-a62c-48fa-ac9c-d424a3c4563d
and trying to guide off of: CONCAT('<div style="text-align:center"><img alt="DOWN" height="20px" src="http://www.clipartkid.com/images/27/download-public-domain-ihtHTQ-clipart.png">','</div>')
0 -
You need to switch to the HTML table card for images to show. Your concat text looks correct.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Thank you. I switched to an HTML table and am using this slightly updated formula:
CONCAT('<div style="text-align:center"><img height="5px" src=',`Image # 1 Actual Content`,'">','</div>')
However, the pictures are still failing to render... do you know why this might be?
0 -
Are you sure that the URL is for the actual image? I typed in that first URL in your screenshot and it took me to a page. That won't to display an image. It should look like this in the case of the first row: https://m.media-amazon.com/images/I/81tA7oHRLVL._AC_SL1500_.jpg
Is that what the Image #1 Actual Content field has as its value? Or is it just that URL in the first column?
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
The image 2 column has values with actual links to images. Below is an example:
0 -
@User_32265 you're missing a " in your formua after src=.
Try this:
CONCAT('<div style="text-align:center"><img height="5px" src="',`Image # 1 Actual Content`,'">','</div>')
Also - 5 px is going to be really small, you probably need to increase that to be able to actually see the image.
1 -
@mhouston provided the following formula which worked! Though I don't see the post on this thread anymore...
Anyways, thanks!
CONCAT('<div style="text-align:center"><img height="80px" src="',`Image # 1 Actual Content`,'">','</div>')
0 -
thank you @mhouston it works
if there a way to enable a preview of the URL by hovering on the link, like a google sheet that shows you the site before clicking?
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 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