Solution to problem with Spreadsheets August 2016

[dwyl]

Solution to problem with Spreadsheets August 2016

[mckennapsean]

This project is not necessarily geared towards Google Forms, but rather for you to build your own forms (and a way to interface with Google Spreadsheets too). You can use some of the javascript code to send you an email, which seems to be working fine.

I tried making a NEW google spreadsheet, and use all the code here to see if I can upload data INTO the spreadsheet. And it worked! I did have to follow all steps here (managing versions to create a new one with the script code, running the "setup" function, deploying as a web app, agreeing to permissions, etc.). Also, the Google Spreadsheet, MUST have all the field names you want to fill in as columns as well as a spreadsheet sheet name of "responses" (or else change this name in the script). After making these changes, it all worked flawlessly for me from a brand new Google Spreadsheet. Make sure you follow all the steps to do this correctly! Let us know if there are other issues or ways to improve the instructions. Thanks :)

[Min11Benja]

I had the same issue, tweaked at it for hours. Yes I forgot to set the access to"anyone, even anonymous" lol so frustrating xD thank god for this post. Thank you guys for making this and giving a step by step instructions.

[mckennapsean]

Not quite sure I understand. It sounds like you are using Google Forms, which is a cool way to create web forms, and you are using it to store information in a spreadsheet. And, it sounds like you may be using this repository as a way to get an email to the manager of the form, so that they get user input as it arrives. Is this all correct?

It sounds like the issue you are reporting is that the script is not working to load data into the spreadsheet. I have tried this with an existing form I have, and tried a new script, and both worked. Perhaps starting a completely new, from scratch spreadsheet would lead to these issues. Is that what you are running into?

Lastly, if all you want to do is send a form to someone's email, I think there is a built in way to do just that... https://www.maketecheasier.com/send-email-notifications-google-forms/

[mvarona]

Yes, I run into this issue when creating a new form from scratch with the script. The script works well until it comes to pass the data to the Google Spreadsheets, that part is not working. I though it was just something mine but I have checked my code many times, and I have seen here that other guys are facing the same problem.

I blame to Google's programatically new way to create their forms, which maybe is gumming up your script, or maybe it's my fault. It doesn't mind because I discovered this approach: wrapping your custom form into an iframe, and then, with ajax submitting two server actions: one to the Google Forms original URL, so that the data is stored into the Spreadsheet, and another –just in case Google changes something in the future, obfuscates its code or something like that– which uses your script to send a copy to the manager's mail. This way you can forget about check your Spreadsheet because if it not up to date, your emails will be.

I don't want the built in way of email notifications because they only notify you when a user has submitted your form, but it doesn't send you their data, so you can't check if it is properly being saved into the Spreadsheet.

[mckennapsean]

This could be related to #45, as the data is not going into the spreadsheet. Basically, you must follow steps 13-16 in order to properly get data stored into the spreadsheet! Hope that helps. Feel free to file another issue if there is something else going on.

[mckennapsean]

Also, another issue could be not following Step 5 correctly to set the script's access to "anyone, even anonymous". See #47

[steveberkhan]

mckennapsean commented 10 days ago

Also, another issue could be not following Step 5 correctly to set the script's access to "anyone, even anonymous". See #47

thank you so much, i think this issue thread is the solution to my problem, first of all i forgot to set the script's access to "anyone, even anonymous", so that was my problem 1 solved. Secondly that "doesn't adding to sheet problem". Thank you so much for letting me know this thread @mckennapsean

[mckennapsean]

Glad to hear it worked out!