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??

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