[HELP] How to create image links in google spreadsheet

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

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

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.