Create Google Drive Image Link

Hi,

Can someone tell me on how to auto-generate google image links for pictures taken & saved in google sheet via appsheet “image” type? What folders should I make public, etc

Much appreciated. Thank you!

If google sheet only saves file names, can we a google image URL out of the file name too??

1 Like

If you add this into the virtual column and the column type is URL, it should generate the link. Please use your own app name, account ID number etc.

=CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=”,“AppName-AccountID”,"&tableName=",“TableName”,"&fileName=",[ImageColumn])

1 Like

CMIIW but I thought virtual columns wont appear in spreadsheet?

Also, instead of creating appsheet link, would it be possible to create google image links instead? sthg like this: https://drive.google.com/a/abc/file/d/1JXVUdkaEvRLqB9hXyUcVt-X-PjD8GhnP/view?usp=drivesdk

Thank you

1 Like

Hi @Chriss, did you ever work this out (link to the Google Drive image)?