How to display images from Google form ? 1) ...

Hi @Heru,

I am doing similar integration of images uploaded via google forms to my AppSheet. But even after following all steps in this article I am still failing to display the pictures in AppSheet from Google Forms.

In my case I have tried an external image in my google-sheet which is read by AppSheet and successfully displayed on the app. Here is the link of this external image and appearance on the app.

The image with green circle correctly displayed by AppSheet.

But Image received in google-drive via google form is not getting displayed in by appsheet, as shown by red circles in the figure above.

Link for google drive image is as follows,

https://drive.google.com/uc?export=view&id=1C4UoXhFBBygOPej-qq1udUvvGWWLMpd1

This link never works with appsheet. But opens correctly if I copy and paste on the browser. And I have an interesting found too which is as follows,

When I try to open google drive image link (which is as follows)

https://drive.google.com/uc?export=view&id=1C4UoXhFBBygOPej-qq1udUvvGWWLMpd1

Then browser successfully opens it, but changes the name of the file as follows,

https://doc-04-84-docs.googleusercontent.com/docs/securesc/0k7orir6fqb6liip6r5onhsodm2h08f8/plu0ionotrvfdas2g046ku18fkqiv5lk/1628841750000/11315055356699011004/11315055356699011004/1C4UoXhFBBygOPej-qq1udUvvGWWLMpd1?e=view&authuser=0

So I tried this new changed url in my sheet, and this time appsheet was able to open the picture without issue. But I believe this cannot be done as a practical approach, because we never know what will be new changed link for each google drive image which is received by google form.

I am reading for last two days and trying to fix this issue, but no luck. Appreciate your support here.

My excel sheet columns are as follows,

Thanks in advance.

1 Like