How to hyperlink values in a Mega Table

NathanDorsch · September 2021

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.

mhouston · September 2021

@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.

NathanDorsch · September 2021

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?

mhouston · September 2021

@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.

NathanDorsch · September 2021

YEs, that worked! Thank you!!!!

NathanDorsch · September 2021

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>')

MarkSnodgrass · September 2021

You need to switch to the HTML table card for images to show. Your concat text looks correct.

NathanDorsch · September 2021

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?

MarkSnodgrass · September 2021

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?

NathanDorsch · September 2021

The image 2 column has values with actual links to images. Below is an example:

https://images.homedepot-static.com/productImages/00f5d65c-67a6-4f1c-a56c-7aa9362a1983/svn/multi-fit-shop-vacuum-attachments-vf2005-e1_1000.jpg

mhouston · September 2021

@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.

NathanDorsch · September 2021

@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>')

German_Rodriguez · December 2022

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?

Charting

Charting

How to hyperlink values in a Mega Table

Welcome!

Best Answer

Answers

Welcome!

Welcome!

Quick Links

Categories