-
Go to Google Forms & Sign In
-
Create a new form
- Follow this exact template
- Press the dropdown menu to the right of the "Send" button & press "Get Pre-Filled Link"
- Enter all forms with random data & press "Get Link", a popup will appear then press "Copy Link".
- Save / copy these values from your link for later
Google Link
Your google link will look something like this, save & copy it for later.
https://docs.google.com/forms/d/e/1FAIpQLSeqIlTE59GOB_yxtowZdVbzoXvMEO_YRTmQ9YKIsLy32A7S-w/viewform?usp=pp_url&entry.2031583407=hello
Entry ID:
The "entry" value after your form id, like so -
entry.2031583407
Save these for later.
- Go back to your Google Form, press on "Responses" & "Create spreadsheet"
- Under line 40 in the file
index.html
Put your Google Entry ID & Google Form Link you collected from earlier to the corresponding variables.
// Put your Google Entry Form ID Here
var Google_Entry_ID="entry.2031583407";
// Put your Google Form Link Here (Make sure to use correct link as documented)
var Google_Form_Link="https://docs.google.com/forms/d/e/1FAIpQLSeqIlTE59GOB_yxtowZdVbzoXvMEO_YRTmQ9YKIsLy32A7S-w/formResponse?"
- Deploy to your hosting provider! Github Pages etc.
Enjoy! :) All responses will be collected in your spreadsheet!