Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

Generate Image Google Drive URL, NOT Appsheet URL

I have seen a lot of posts about how to get the URL for images taken by an app sheet app, but these URLs are always a link to appsheet:

CONCATENATE(
  "https://www.appsheet.com/template/gettablefileurl",
  "?appName=", ENCODEURL(CONTEXT("AppName")),
  "&tableName=", ENCODEURL(CONTEXT("Table")),
  "&fileName=", ENCODEURL([image-or-file-column])
) 

My app stores the images in my google drive by following a folder path. Is there a way to produce a URL that will link to the image in my google drive and not the image in app sheet? I am using this URL for other purposes, and a link to app sheet will not work. It needs to be a link to the file in my drive. 

0 1 83
1 REPLY 1

Steve
Platinum 5
Platinum 5

It might be possible using data available by making a folder a data source: Use data from Google Drive

Top Labels in this Space