Image links from Google drive

[Doron_Assis1]

Hi everyone,

Is there a way to list the an image URL once it uploaded onto Google Drive ?
When an image is uploaded, the data sheet only list it’s name, something like:

“list_Images/22152Place_A1_52.image.095130.jpg”

What I’m looking for is it’s URL within the Google Drive.

Can it be done ?

[Kirk_Masden]

This might help:

Please help - would like to move image Gsheet and image folder locations Questions

@Kirk_Masden Go information pane, and then Property tab. By default, it display the relative path to your app folder for image . After you move the folders somewhere else, you just modify this relative path so that Appsheet to start to read the image from the new location. Try. [image]

I don’t have time to provide a complete explanation now but the short answer is that it’s definitely possible.

[Kirk_Masden]

This might help too:

[HELP] How to create image links in google spreadsheet Questions

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”,"&fileN…

[Kirk_Masden]

This might be better:

Google drive links Questions

This should work… CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=",“YourAppName-YourAccountIDnumber”,"&tabl...”,[PdfColumnName])

I got it to work with my own app but the “table name” confused me. You need the name of the table in your app, not on your Google sheet.

[Kirk_Masden]

One more:

Hi! This post will be a quick tip for people ... Questions

Hi! This post will be a quick tip for people who don’t yet know how to make images that they’ve captured in their apps visible inside their Google spreadsheets. Then, I’d like to pose a question about the expression we use to make this happen. First of all, the image you see shows how an image that I captured through my app appears in my spreadsheet. This magic is explained here: Displaying Images and Documents https://help.appsheet.com/ux/views/displaying-images-and-documents The spreadshe…