Create Google Drive Image Link

[Chriss]

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

[Aleksi]

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])

[Chriss]

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

[Derek_Morgan]

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

[sen]

any solution on this yet?

[sen]

No solution for this yet? including Appsheet?

[Steve]

Not possible.