Hi there! Most of the time, we use Google Docs, Google spreadsheets and Google presentation in our day today life, may be for your college works or as a part of your job tasks. But, most of us haven't use Google Forms or you may have used it once or twice. So I thought to show you how to use Google Forms in no time.. Let's get started! 😃
What is Google Form?
It is the best way for collect information from large group of people or even a small group of people nowadays. Lots of people think of it as a way to create surveys and it's great for that, but there are lots of benefits other than surveys from Google Forms. You will identify those eventually.
Let's create your own Google Form!
First go to a new tab in Chrome and select the Googles app icon in the top right corner of the tab. And click on the Google Drive Icon. Then you' ll move to your drive page.
Then click on the "Next" button (blue). You'll get a drop down menu. From that select "More" option. Now you'll see "Google Forms" option in the next drop down. Move the cursor on to it.
You can create from the a new blank form or you can choose a template from here. I'll go with "From a template" option since it is easy and I can save my time too. (These tools are there to do something faster and in an effective manner. So as my opinion, starting something from the scratch will consume more time. If it's not an assignment or any other thing that plagiarism matters, there's no point of wasting your time for unnecessary things. Use these templates.Be effective! Not ordinary 😉)
In the template gallery there are many templates that you can use for different purposes such as Event registration, T-shirt signup, RSVP, Contact Information, Job Application etc.
For this tutorial I will show you how to create a Event Registration form and how to get the responses to a google spread sheet.
So I have chosen Event Registration Template from the Gallery. Then It will open up the template in an editable manner.
You can see we have two tabs. One for the questions and one for the responses. Let's start with the Questions tab.
In the first line, You can add a title to the Form. Below that you have a space to enter any description about the event.
If you want, you can add an image (may be a post/banner of the event) to the form by clicking the image icon next to the form.
There you can add a title to the image, duplicate and delete it too. Apart from that you can align and add a hover text to the image too.
OK!. Let's move on to the fields in the form. You can add a new field by clicking the plus icon in the right side of the form. And you can change the field type, add images, duplicate and remove your field too. There are many types of fields such as Short answer, paragraph, multiple choice etc. Anytime you can convert a field from one type to another.
One good benefit of Google forms is you can validate responses. There are 3 methods to do it.
Apart from these basic features if you want to add another section(page) to your form you can click on the icon which is below the youtube(video) icon in the right corner of the form.
Well done! now you can create a Google form and you know all the basic steps of creating it. Let's see how to get the responses of our Google Form to a Google Spreadsheet.
Go to your responses tab in the form. Click on the "create spreadsheet" icon. You can create a new spread or use an existing one for collect responses. In this case, I created a new one.
After this step you will get a spreadsheet with field names given in the form as column names.
Apart from these things ;
What is Google Form?
Let's create your own Google Form!
First go to a new tab in Chrome and select the Googles app icon in the top right corner of the tab. And click on the Google Drive Icon. Then you' ll move to your drive page.
Then click on the "Next" button (blue). You'll get a drop down menu. From that select "More" option. Now you'll see "Google Forms" option in the next drop down. Move the cursor on to it.
You can create from the a new blank form or you can choose a template from here. I'll go with "From a template" option since it is easy and I can save my time too. (These tools are there to do something faster and in an effective manner. So as my opinion, starting something from the scratch will consume more time. If it's not an assignment or any other thing that plagiarism matters, there's no point of wasting your time for unnecessary things. Use these templates.Be effective! Not ordinary 😉)
In the template gallery there are many templates that you can use for different purposes such as Event registration, T-shirt signup, RSVP, Contact Information, Job Application etc.
For this tutorial I will show you how to create a Event Registration form and how to get the responses to a google spread sheet.
So I have chosen Event Registration Template from the Gallery. Then It will open up the template in an editable manner.
You can see we have two tabs. One for the questions and one for the responses. Let's start with the Questions tab.
In the first line, You can add a title to the Form. Below that you have a space to enter any description about the event.
If you want, you can add an image (may be a post/banner of the event) to the form by clicking the image icon next to the form.
There you can add a title to the image, duplicate and delete it too. Apart from that you can align and add a hover text to the image too.
OK!. Let's move on to the fields in the form. You can add a new field by clicking the plus icon in the right side of the form. And you can change the field type, add images, duplicate and remove your field too. There are many types of fields such as Short answer, paragraph, multiple choice etc. Anytime you can convert a field from one type to another.
 |
| Changing the field type. |
One good benefit of Google forms is you can validate responses. There are 3 methods to do it.
- You can make a field "Required" by Enabling the required button. Then Recipient cannot submit the form if he/she has't fill that relevant field. So you can add enable this feature in a fields that are the most essential .
- You can add instructions to fill the field as a description to the field. Then the receiver of this form will understand how to fill it properly.
- If not, you can restrict the response by ticking response validation option. Here you can limit response to a number format, test format etc. And you can add an error message too.
Apart from these basic features if you want to add another section(page) to your form you can click on the icon which is below the youtube(video) icon in the right corner of the form.
Well done! now you can create a Google form and you know all the basic steps of creating it. Let's see how to get the responses of our Google Form to a Google Spreadsheet.
Go to your responses tab in the form. Click on the "create spreadsheet" icon. You can create a new spread or use an existing one for collect responses. In this case, I created a new one.
After this step you will get a spreadsheet with field names given in the form as column names.
Apart from these things ;
- You can limit responses from one user to exactly one.
- You can give the editing access for the user's response after submitting.
- Make a confirmation message and more
Great! Now your form is ready to share with other people.
You can share directly via emailing or through social media such as g+, fb and twitter. If not you can get a shareable link. (Important : you can shorten your link too). And if you want this form to be shown in your website you can get an Embed HTML code too. Here is my Google Form. & Here is the response sheet . You can have a look. 😊
When you want to stop receiving responses. You can simple disable "Accepting responses" button in responses tab.
If you like my articles and tutorials please click "informative" icon below and subscribe my blog.
Thank you.
| Kalpani Ranasinghe |
| email: kalpanibhagya.kb@gmail.com |
Comments
Post a Comment