Use Image's routes inside google data studio?

[Cucho]

Well, i think that this could be a powerfull application to the images, to just take my appsheets pictures and be able to show them on google data studio.
Sadly, Data Studio only works with URL for the images, and Appsheet saves them organizing quite well the folders and giving a key related name.

Is there a way i can get the URL from Appsheet’s images?

That’d be soo cool!

[Koichi_Tsuji · Accepted solution]

help.appsheet.com

Displaying Images and Documents

How to display documents and images in your app.

Construct your URL manually based on your app. Then just simply place anywhere you want.

[Kirk_Masden]

@Cucho , you might be interested in this tip too. It’s not exactly the same as what you are trying to do, but I think it’s similar.

Sharing text AND IMAGES through Google sheets Tips & Tricks 💡

If you are storing the data for your app in Google sheets, you are probably aware that you can, if you choose to do so, share that sheet which someone else and thereby share any text or numerical data in that sheet. Are you aware, though, that you can also share images in this way? It’s actually quite easy to do. The following image displays data that my students have shared with me, along with my comments and evaluation: [Screen Shot 2020-12-07 at 21.07.15] Each student in the class is us…

[Cucho]

Woah!!! That will help a lot! it’s a great idea.
Thanks!

[Cucho]

Thank you very much!!! that’d be so helpful!

[Cucho]

Hey @tsuji_koichi I just worked on this topic, and on the format:

=CONCATENATE("https://www.appsheet.com/template/gettablefileurl?appName=", ENCODEURL("AppName-Account#"), "&tableName=", ENCODEURL("TableName"), "&fileName=", ENCODEURL(+ImageColumnCell))

The +ImageColumnCell part at the end didn’t work for me. What worked was to change that for:
[IMAGECOLUMN] changing the cellname for the input that appsheet gives with the Image’s location and name on your google drive.