Anyone else having issues with connecting Goo...

(Jack Edwards) #1

Anyone else having issues with connecting Google Forms to Appsheet?

(Jack Edwards) #2

Note, I tested this several times, but I got this error on a brand new form with one yes or no question on it.

(Dinh Nguyen Nguyen) #3

@Jack_Edwards Hi Jack, “app is not runnable” usually indicates that there is a critical error in the app. I assume you were using the Google form add-on to create the app. Did you run into this error immediately after creating the app from the form? Could you check the app to see if there is any error in the app?

(Dinh Nguyen Nguyen) #4

@Jack_Edwards Hi Jack, could you double-check to see if the Google account that owns the form and the Google account that you use to log into AppSheet are the same account?

(Jack Edwards) #5

I was logged in a couple times, but I did confirm that the Form owner is also my Appsheet account

(Jack Edwards) #6

@Harry I can try and start a new form with the appsheet login ID Only if you think that will help.

(Dinh Nguyen Nguyen) #7

@Jack_Edwards Hi Jack, that won’t be necessary. I just wanted to confirm that the app was looking in the right account for the form. We are debugging this issue right now and we’ll get back to you soon.

(Jack Edwards) #8

@Harry Thank you


@Jack_Edwards We just released a fix, however the broken app will probably still be in a bad state. The simplest way to proceed would probably be to make a new copy of the form and run the add-on again to generate a new app. If you do want to try to recover the first app you would need to find the UX Views that are pointing to the wrong data source and either change the data source in the view settings or delete the view (I found for the table view I could change the source, but the form view I had to delete it and then add a new one).

(Jack Edwards) #10

@Adam_Stone_AppSheet Thank you… I will re test with a new form shortly.

I appreciate you guys jumping on this.

(Jack Edwards) #11

@Harry @Adam_Stone_AppSheet Success!

Thank you both!

(Jack Edwards) #12

@Harry Correct.

I used the add-on, and this is the first thing that pops up on my screen after I hit the “launch” button

(Dinh Nguyen Nguyen) #13

@Jack_Edwards Hi Jack, if this was the first thing that occurred right after you created the app using the add-on, there might have been an error parsing the form. Could you give us more information about the form? Does it have any special settings?

Adding @Adam_Stone_AppSheet to investigate further.

(Jack Edwards) #14

@Harry It was literally one yes or no multiple choice question and a submit.

I have been able to recreate this several times if you need a new live example of it.

(Dinh Nguyen Nguyen) #15

@Jack_Edwards Hi Jack, it would really help if you could share a test form with us that can reproduce this error consistently. Thank you.

(Jack Edwards) #16

@Harry Here is a screen shot of a brand new form I just tried to launch in Appsheet via the Add-on.

What is the best way to share this with you?

(Jack Edwards) #17

Appsheet Error Sample

Here is the link to the Google Form Appsheet Error Sample

(Dinh Nguyen Nguyen) #18

@Jack_Edwards Thank you Jack. We’re looking into this and will get back to you as soon as possible.

(Jack Edwards) #19

@Harry Really apprecaite it, let me know what other info I can supply you with.