How to integrate a form

AppSheet AppSheet Q&A
, ,
1

Hey everyone!

I’m trying to create an app for my family to vote on what they want to eat for dinner, out of the dishes my mom makes.

I’ve run into some problems in the process:

  1. I’ve created a google form for my family members to vote on the dishes they would like best. I’ve tried to integrate the form into Appsheet, I’ve added the form as a data source, and then added a view for it, but it has an error and only shows the time stamp.

JordanFing_0-1731277078064.png
JordanFing_0-1731277078064.png714×964 27.2 KB

Also, the view shows an error:

JordanFing_1-1731277178013.png
JordanFing_1-1731277178013.png1348×302 19.7 KB

  1. The photos of the dishes in the “menu” are broken and wouldn’t show. I’ve uploaded them into google drive and put the URL but it still doesn’t work.

Thanks so much!

2

Change the view’s type from form to detail.

Steve_0-1731336403739.png
Steve_0-1731336403739.png576×278 19.4 KB

1 Like
3

Thanks!

And how do I make the pictures show and not an error?

4

Make sure that each picture on google drive is shared as Public with the link

1 Like
5

Still doesn’t work.. It doesn’t show the form:

JordanFing_1-1731405074179.png
JordanFing_1-1731405074179.png2178×1110 179 KB

6

Do your photos show when you use an incognito browser window to view their link?

1 Like
7

Yes..

8

So I’ve just remembered that Google changed how links to non-Google files such as images are handled now. Unfortunately, until Appsheet implements iFrames (work in progress still I believe) you cannot use the sharing links from drive to get images into appsheet anymore.

But!, you could upload your images to a third party such as Dropbox and generate a link from there…then you can use that link instead of the one from google drive.

1 Like
9

And I’ve also just remembered that the folder that Appsheet uses to store it’s files is special. You can create or move your images to that folder and refer to them via their filename instead of links and they will show.

https://support.google.com/appsheet/answer/10107317?sjid=13974529130428842210-EU#filename

1 Like
10

Thanks for the help!
I’ve tried doing the url replacement trick and it didn’t work.
Also had a look at Dropbox but it’s not free and I’m not looking to invest money in this project at this moment.
I couldn’t understand from the link you provided what is the process I should do..

11

The best way to investigate this is to quickly make yourself a brand new app.

Let the table just have 2 columns. One for a uniqueid() and the other for an Image column.

Use the app to add some records…for each of the added rows, upload an image of your choice and save.

Now, take a look inside the folder that Appsheet created for you when you started the new app. Inside that folder will be an Images folder..and inside that will be the images that you uploaded…one for each record you added.

The images are named strangely because Appsheet has to be sure that the image name is unique as it relies on the Image Name attribute rather then a fileid to find and display the images in your app. Note that this is NOT the same as displaying an image using a URL. Images in this folder are displayed using a filepath/imagename method.

Take a look inside the data source that your records are being saved into. You can see that your image column contains the full path and name to where the image has been placed.

From this point onwards, you should be able to work out what is going on and adapt your real app to use this method.

1 Like