Google Drive Image with AppSheet?

mykrobinson · 01-26-2022 08:13 AM

Good morning, all. I am very new to AppSheet, a couple days to be exact. I am working on a couple of relatively simple apps to get my feet wet. The first portion is a directory of clinics with maps, contact info, etc.

The second is an employee directory, and here is where I am having trouble, We have employee photo already available in a shared Google Drive. I have temporarily set the share permissions to allow anyone with the link to view the files in the target directory.

I read this article
https://help.appsheet.com/en/articles/961605-displaying-images-and-documents

And have followed the steps to reformat the shared link per the article, so that

https://drive.google.com/file/d/XXXXXXXXXX/view?usp=sharing

becomes

https://drive.google.com/uc?export=view&id=XXXXXXXXXX

the link works in the spreadsheet andor browser, but not in AppSheet. Having a hard time figuring out what i might be doing wrong here.

Any pointers?

Thanks

jyothis_m

I also faced the same issue. The easiest way i found was to upload 1 photo from Appsheet itself and see what link comes in the Google sheet. The same path and location can be used for the remaining photos. I.e. remaining photos can be uploaded to the same folder and link can be added based on that.

Craig_QREW

Hello, I encountered this same problem. I made a short video to show you have I had fixed it. I hope it helps, basically you can add the image you want into your app through the app emulator. That worked best for me and it saved me from having to worry about the formatting so much.

Craig

QREW Technologies

Adding images to AppSheet

mykrobinson

Thanks for this. I found it works fine by uploading through the app, but I am hoping to use pre-existing photos in a shared space, if possible, so as not to reinvent the wheel. I guess it also bugs me that the AppSheet document clearly lines out what needs to be done in order to use Google Drive resources, but I can't get it to work as prescribed.

jyothis_m

That's what i suggested. Try uploading just one photo directly from the app and see the location where its saved and link that generates in the gsheet. Remaining photos can be copied to the same folder and link may be created in a similar manner easily.