Submit to a google spreadsheet using a form of your own design
Submit to a google spreadsheet using a form of your own design.
I have updated this documentation to keep up with the changes Google has made to forms. The process now varies slightly from when this readme was originally published.
Build a google form with a question that you want to collect data for, and make sure it is public. View the form, and click on the "responses" tab. In the settings for the form (the 3 dots in the upper right) choose "select response destination" and make sure it logs to a new spreadsheet.
View the form by clicking the "eye" icon in the upper right at the top of the page.
On the live form page where you can submit responses, view the source of the page, and capture the URL in the
actionattribute of the
https://docs.google.com/forms/d/18LD6ueL10_lLVAKpDgfmLpUBlzoRFEZSoMod57MXfH0/formResponse?hl=en_USgetting rid of everything after
Now search the source of the page for this:
Some people have asked about incorporating multiple questions, so I've included an
index2.htmlfile which shows a form with two questions.
Essentially, you just need to make sure your submit URL looks like this:
where you just keep separating each question and answer with an ampersand.