Thank you! Great instructions. 👍

@yagisanatode

7 күн бұрын

Glad it was helpful!

Thank you! Very helpful, even in 2023!

It worked! Thanks man, great explanation :D

Thx a lot Yagi !

Great video! Very clear and easy to follow. Appreciate the help.

@yagisanatode

10 ай бұрын

Glad it helped!

Thank you for this tutorial! So clear. It helped me greatly!

@yagisanatode

2 ай бұрын

Glad it helped!

Thanks a lot! This was really so helpful!

@yagisanatode

Жыл бұрын

Glad it was helpful!

This was so helpful. Thank you for sharing~

@yagisanatode

Жыл бұрын

Glad it was helpful!

This is really helpful. Thanks.

@yagisanatode

Жыл бұрын

Glad it was helpful!

UPDATE 2023! : To access Publish to the Web in Drawing you mush now go to File > Share > Publish to the Web. This is a new update to the Drawing User interface in 2023. Thanks to @dontknowwhattotypelo for bringing the change to my attention.

I though google would make such a function easy way, but they did not. But You did, so thanks a lot!

@yagisanatode

Жыл бұрын

You're welcome!

awesome, thank's a lot!!!

@yagisanatode

Жыл бұрын

You're welcome!

Many Thanks

@yagisanatode

Жыл бұрын

You are welcome

thanks man

@yagisanatode

10 ай бұрын

No problem!

Perfect Tuto, explaining non working possibilities first, then solutions. Why is there an impossibility to use the link from images stored on the Google Drive ? Is it a security limitation ? Because it is so annoying to not be able to use them ! Seriously, what a nightmare to do something so simple et very useful.

Awesome video! Any idea how to make the links still clickable once I export as a PDF? i.e. the link is clickable in the PDF?

@yagisanatode

Жыл бұрын

Thanks for the kind words. Unfortunately, Googles export builder does not yet have that functionality.

This tutorial worked great! One issue however, whenever I try to follow the first example with PNG's, the transparent background turns black. Is there a way to prevent this?

@yagisanatode

11 ай бұрын

Hmm, that's annoying. You might have to fill the transparent part to white unfortunately.

Hey Yagi - got everything working almost great. The hyperlinks and images are all working perfectly on the sheet itself. The issue I'm having is when I publish it as a website and then embed it on my website, none of the image links are usable (no links pop up to click), except for the text links. Do you know of a solution?

@yagisanatode

Жыл бұрын

Website exports can be notoriously unreliable with with Google Workspace and Microsoft files. While they can provide minimal XML/HML conversion they are definitely not designed for it unfortunately.

@Drew_Haus

Жыл бұрын

@@yagisanatode Thanks for the reply, really appreciate it!

Awesome! Super helpful. Thanks! Only challenge is I have all of my images etc on Dropbox rather than google drive and it appears they don't want to play in the same sandpit. Do you know of any other way around it without me havign to transfer my whole dropbox to google drive? TIA

@yagisanatode

5 ай бұрын

My understanding is that Dropbox (and, I guess Google Drive) is not intended as a content host for websites. Perhaps a workaround, that I have not tested, might be to retrieve an image using the Dropbox API and then convert it to a blob in Apps Script before saving it to a file in Google Drive.

I published my google sheet as a webpage, it works great on pc, but the hyperlink doesnt pop-up when viewing in ios on the iphone. you click on the image but nothing happens. any ideas?

@yagisanatode

6 ай бұрын

Unfortunately links and menu items don't work in the Mobile App. You can try replacing the button with a checkbox and onEdit() trigger though. Some Links: yagisanatode.com/add-the-current-date-to-a-sheet-when-data-is-added-so-that-the-date-does-not-changestatic-google-sheets/ yagisanatode.com/add-the-editors-email-when-they-tick-the-check-box-in-google-sheets-with-apps-script/

Thank you!

Hi Yagi, any idea why the links don't show when exporting to pdf? I've been using an image from a google folder option. It all works great on google sheet but no links when exporting... TIA!

@yagisanatode

Жыл бұрын

Hi Beatrice, I don't think the conversion software that Google Uses allows for links for exporting to PDF unfortunatley.

I'm wondering if there's a solution for adding a link to an image that is "over the cell" rather than in the cell

@yagisanatode

Жыл бұрын

Hi Joshua. Not directly. The best you can do is something like this: kzread.info/dash/bejne/npWCy6ltns-8edY.html

@JoshuaNgMusic

Жыл бұрын

@@yagisanatode Thanks I'll try it out!

This is very useful tutorial 🎉 How can i create an album in Google sheets for my images in Google drive if i have over 200 images?😢

@yagisanatode

10 ай бұрын

You could apply the same principles as the tutorial below to extract the image thumbnail for the selected cell: kzread.info/dash/bejne/k5OWuMain9a1gZc.html

@TechnoEveryday

10 ай бұрын

@@yagisanatode thanks a lot for the example I am afraid that coding isn't my baby ......

@yagisanatode

10 ай бұрын

@@TechnoEveryday All good. You can actually sort your Google Drive by type (image) and a bunch of other selectable parameters. This will generate a URL with the custom search that you could bookmark. It might be an easier code-free workaround for you.

@TechnoEveryday

10 ай бұрын

How will it populate the images in Google sheets?

@yagisanatode

10 ай бұрын

@@TechnoEveryday The last one mentioned above is not a Google Sheets solution. Just a suggestion for an alternative to creating and managing an album.

It still did not show the image...ugh. I've been at this for an hour. It is blank but has the link but with no image

@yagisanatode

Жыл бұрын

What sort of link are you using? A Google drive URL or something else?

I followed your steps. I get the image in the cell but it doesn't link to anything. Did Google come up with something which doesn't allow us to add a link to an image anymore?

@yagisanatode

11 ай бұрын

What sort of URL are you using? What are the sharing permissions for the URL that you are using?

11 ай бұрын

@@yagisanatode Thanks for replying. I did a Google Drawing button, published it and got the URL. I've inserted that URL, just like what you've shared in the video. I guess when we publish the image, it is deemed public, right?

@yagisanatode

11 ай бұрын

@ Are you publishing from a Google Workspace Domain account or from a shared drive? Sometimes the admin can turn off sharing. support.google.com/docs/answer/183965?hl=en-GB You can also test this by going into Incognito mode on your browser and pasting the URL to see if it is accessible.

11 ай бұрын

@@yagisanatode Yes, Workspace Domain. I'm the admin though. Any resources to turn the sharing on? But I got a share link. That means it is on, right? And also, I have published a few Docs before and I had no problem with that.

@yagisanatode

10 ай бұрын

@ I can't seem to replicate the issue. How is your link displayed in the first argument of the "HYPERLINK" argument?

It shows as "Error" when i do like this :(

@yagisanatode

Жыл бұрын

What does the error message say? What image URL are you using one from Google Drive?

@caio7208

Жыл бұрын

@@yagisanatode i tried to substitute "," between the hyperlink and the image line of codes with ";" and it worked!

@yagisanatode

Жыл бұрын

@@caio7208 Awesome!!!

@caio7208

Жыл бұрын

@@yagisanatode Thanks to you

doesn't work in 2023

@yagisanatode

Жыл бұрын

Hey thanks for letting me know. I've just reviewed all the approaches again. Good news, they still work. I think you are referring to the missing 'Publish to the web' link in Drawing. It has been move to File > Share publish to the web.