[HELP] How to create image links in google spreadsheet

AppSheet AppSheet Q&A
,
1

Hi. Im having a very hard time constructing a simple url to view images in my google sheets. I believe its because of my “spaces” in my table, folder & file name…

Example
appname = “my app”
table name = “my table”
file name = “my table_images/A1234.Image 1.12.30 PM_Track_1234.jpg”

note: my table_images is an auto generated folder created by appsheet. pictures are inside with name: 1234.Image 1.12.30 PM_Track_1234.jpg → “this has 2 spaces”

can someone help me generate the applink using the above example? I want to see when we do use %20, what to do with “/”

the following encoding example didnt work
=CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=”, ENCODEURL(“Inventory-114348”), “&tableName=”, ENCODEURL(“Orders”), “&fileName=”, ENCODEURL(+B2))
from the following site
https://help.appsheet.com/en/articles/961605-displaying-images-and-documents

i tried copying this too, replacing space with %20 but it also didnt work.

https://www.appsheet.com/samples/How-to-have-images-show-up-in-your-Google-Sheet?appGuidString=e161a3d2-8b5f-4246-957b-61677be0e81f

Am i missing something?

Thank you very much for the help

2

Please scroll that article to the bottom where you can see a formula like =IMAGE(CONCATENATE…))

3

I’ve done this before and I didn’t use ENCODEURL, even though I see it is used on a page you referenced. Instead I used:

=SUBSTITUTE(CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=“,Kankaku!A$8,”&tableName=”, “Notebook”,“&fileName=”,I8), " ", “%20”)

When I just tested it in the sheet, I didn’t have any spaces in my URL so the following also worked:

CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=“,Kankaku!A$8,”&tableName=”, “Notebook”,“&fileName=”,I8)

In this “Kankaku!A$8” is a cell that holds the name of the app and “I8” has the name of the image.

And, as @Aleksi has pointed out you need to put the URL in something like

=image(Q8)

(Q8 is the cell with the URL) in order to get it to show in your sheet.

4

Hi, could you show me what the full url would look like?

5

Actually, I don’t use this in my app any more and I can’t get the old Google spreadsheets I still have to display things properly. I’m not sure is something has changed or not. Perhaps @Grant_Stead can help:

[Take image from image column and display as link](https://community.appsheet.com/t/take-image-from-image-column-and-display-as-link/20014/17) Questions

So, It’s further down in the help article that I sent you… Format: =CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=”, ENCODEURL(" AppName-Account# “), “&tableName=”, ENCODEURL(” TableName “), “&fileName=”, ENCODEURL(+ ImageColumnCell )) Sample: =CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=”, ENCODEURL(” Inventory-114348 “), “&tableName=”, ENCODEURL(” Orders "), “&fileName=”, ENCODEURL(+ B2 ))) To find the application name to include in the …

6

Hello, I’m new to Appsheets and I see this topic has been widely explained. Sorry for my ignorance but I can’t understand how to make thids work. Could someone walk me through the steps? I have an image column but obviously the image file saved in my googlesheets is no use. I need a link in googlesheets so anyone can open the image saved. Thank you!!

3X_8_9_899f12b1b8ac232f9fb45967ebca965134ef0ef6.png
3X_8_9_899f12b1b8ac232f9fb45967ebca965134ef0ef6.png1678×141 18.3 KB

7

Hello @Chriss, I have solved the link generation very recently using google scripts, you can check out this post if you’re interested in trying that out:

[Uploading images from app into google sheets](https://community.appsheet.com/t/uploading-images-from-app-into-google-sheets/57440/6) Questions

I got it to work !, here’s the code: function getLinks() { const folderID =“1ABCGkLB9QqNccdASLwdf_rdffRzTUp_G”; // This is the ID of the folder where the images are const sheetName = “Images” // This is the name of the sheet that contains the image names const linkColumnNumber= 2; // This is the number of the column that’s going to contain the link to the images, it is counted starting from 0 at column A (example, column C would be number 2) const nameColumnNumber= 1; // This is the number of t…

8

Any solution yet?

9

Not possible.