-
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/1FAIpQLSfy-tWg12-h-gbtJbk5g5GTPUpNZg2iML1fPgcAkNgJfqgzMQ/viewform?usp=pp_url&entry.1416717319=a&entry.2145923340=a&entry.355339717=a
Form ID:
the part that says "YOUR GOOGLE ID" will be your Google Form ID.
https://docs.google.com/forms/d/e/YOUR GOOGLE ID/viewform?usp=pp_url&entry.1416717319=a&entry.2145923340=a&entry.355339717=a
Entry ID(s):
The 3 "entry" value(s) after your form id, like so -
entry.1416717319, entry.2145923340, entry.355339717
Save these for later.
- Go back to your Google Form, press on "Responses" & "Create spreadsheet"
- Under line 44 in the file
index.html
Put your Google Entry ID's & Google Form Link you collected from earlier to the corresponding variables.
The first entry ID is "Name", second entry ID is "Email" & third is "Textarea"
var Google_Entry_ID_Name="entry.1416717319";
var Google_Entry_ID_Email="entry.2145923340";
var Google_Entry_ID_TextArea="entry.355339717";
// 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/1FAIpQLSfy-tWg12-h-gbtJbk5g5GTPUpNZg2iML1fPgcAkNgJfqgzMQ/formResponse?"
- Deploy to your hosting provider! Github Pages etc.
Enjoy! :) All responses will be collected in your spreadsheet!