Before we go to our specific task we know about Google form and Google spreadsheet and process to submit data into Google spreadsheet from Google form
First method we used Google Forms and there would be some field user input some value and then the data is saved into Google spreadsheet.
In the figure we saw that the Google form data is sent to Google spreadsheet.
Output Will like Here
Second Method we used our custom form and send HTTP request to Google form and Google form send the request automatically send the data to Google spreadsheet
In the figure we saw that the The process of sending data to Google spreadsheet from out form by HTTP request
Step -1
Search Browser for Google forms or go to docs.google.com/forms/create
Note: You must have a Google account for the form creation.
After reached Google forms create a Google forms
And must do following work
Step -2
In Google Forms anyone can add different types of forms element like text, Date , number, image field and others
Step 3 :
In Advance setting option you can add Data validation rule and required or not rule
Step -4
We can add form validation rule in Google form. In email filed once can only input email address , others will be invalid. Google form give this facilities
Form Validation Rule Click Here For All Google Form validation rule : Click Here
Step-5
Another example of form validation (word limit of a post)
Step 6
In this step we will keep the link because this link visual form link
Note: For good SEO and beautiful link you can short the link
Step -7
After Trigger the send form button in step 6 this form is appear.
This is the most important page where you can link the form to google spreadsheet . which is keep in google drive. You can change is later.
Step -8
After all step done and enter the link we copy in step 6 the complete form looks like this.
Step-9
When a user submit data in form show in step 8 this show the response
Step -10
Ohhhhhh… Our data is saved in Google spreadsheet
Step -11
Note: One thing you may know but is important to know that when you edit a form or create a form in google form google will automatically saved your data in google drive
All your form and spreadsheet data is saved in Google Forms
Note: Google drive is work as Server side in whole process.
Live Demo :
View Google Form Here : Click Here
View Your Submit Data In Google Spreadsheet Here: Click Here
In this process we don’t use Google form to send data in Google spreadsheet, instead we use our custom form and send http request from our website and send data google spreadsheet
Before this we create a Google form in previous topics
Note : It is good Practice not to use validation rule in Google form if you sent HTTP request from your site .
If you use form validation rule in Google form then you must have to use same validation rule in your forms.
Step – 1
Step 2
In this step we copy the field’s “name” and “id” show in image for future use
Step 3
repeat the process for all forms
Step 4
After paste the code the code looks like this
Step 5
This is our final forms .
Note: All The form field must same in Google form. Otherwise the forms does not work
Step 6
After triggering the submit button out data will save in google spreadsheet
View Custom Form Here : Click Here
View Your Submit Data In Google Spreadsheet Here: Click Here
Download Sample Code : Click Here
Step into the future with CyberNetikz, where we craft tomorrow’s tech innovations with today’s coding artistry Mega Medusa Casino.