How to convert the image path in google sheet into hyperlink?

[sen]

hi Everyone,

How to convert the image path in google sheet into hyperlink?

Anyone can share? Thanks. 

I have upload image from appsheet, in google sheet I can't have the hyperlink to open that image directly (Image stored in google drive). Appreciate if someone can share the step by step solution. Thanks.

Expected result:  In the google sheet, under image column, every image will have their own unique URL, eg: https://drive.google.com/uc? ....

[Suvrutt_Gurjar]

Please take a look at the section "External URL for image files" in the article below

Display images and documents - AppSheet Help

[sen]

Thanks for your sharing Suvrutt, anyone else sharing? 

[Steve]

Is there something wrong with @Suvrutt_Gurjar's advice?

[sen]

Can advise the solution for my case? Thanks. 

[sen]

Hi, Thanks for your reply.

To make more understand, you may refer to the attachment that I uploaded. I wish to know what is the steps to auto construct the image file location with hyperlink inside google sheet after every new data submission. As you can see, currently the image file path only available in normal text where user cannot click & view the image directly from the google sheet table. 

Appreciate if someone can share the step-by step to setup the hyperlink in the google sheet.  Thanks.

[Suvrutt_Gurjar]

The referred article describes in detail how one can create a URL that is available in Google sheets for the uploaded images.

Once you construct URL based on the help article, you can use Google sheet's HYPERLINK() function to construct a hyperlink based on that URL, since you want the hyperlink to be available in the Google sheet itself.

[sen]

Noted. So where should I put the Hyperlink() function? can advise

For your info, the below attachment is my current setting in virtual column.

[Suvrutt_Gurjar]

Since you want hyperlink in Google sheet, please use HYPERLINK() function from Google sheet itself.

here is an example. The Column C contains URL created. Column E has Hyperlink by using Googlesheet Hyperlink() function.  Hyperlink in column E  uses URL from the column C and hyperlink label from column A  with formula HYPERLINK (Cn, An) where n is row number.

Relevant cells and formula highlighted.

[sen]

Thanks for your sharing. Is it possible to create the hyperlink to link to google drive itself?

My expected result: User can click & view that image via hyperlink in google sheet. Every new image uploaded from Appsheet to google sheet/drive will auto generated hyperlink & store in the column instead of showing normal text only. Anyone got solution? 

[Suvrutt_Gurjar]

I think whatever I suggested does exactly as per your requirement. To achieve your requirement, I believe a couple of steps as suggested will need to be implemented.

Someone else may help you with a better solution.

[sen]

Thanks for your help Suvrutt_Gurjar.

[sen]

The filename behind the link is not appear during save, until the app user re-save again, then the full link only will display completely. Anyone facing this problem?