[HELP] How to create image links in google spreadsheet

Chriss
New Member

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=e161a...

Am i missing something?

Thank you very much for the help

0 8 4,157
8 REPLIES 8
Top Labels in this Space