Up next in 10
7 Google Form Tricks You MUST Know (Updated)
346 views
Feb 19, 2024
The video "7 Google Form Tricks You MUST Know (Updated)" introduces viewers to seven advanced techniques for maximizing the functionality and efficiency of Google Forms. It likely covers various tips and tricks, such as utilizing add-ons or extensions to enhance form capabilities, implementing branching logic to create dynamic forms, integrating with other Google Workspace apps for seamless data management, and customizing form themes for a personalized touch. The tutorial may include step-by-step instructions and practical examples to demonstrate how to implement each trick effectively. By offering valuable insights and strategies, the video aims to empower users to create more dynamic and impactful forms for surveys, quizzes, or data collection purposes. Overall, it serves as a valuable resource for individuals seeking to elevate their Google Forms proficiency.
View Video Transcript
0:00
In this video, I'm going to show you seven Google Form tricks which are going to enhance your Google Form
0:06
So if you already have a form, then this video is for you, but if you haven't created one yet
0:12
you can check out my tutorial on the top right of the screen. So let's get started
0:17
First, I'm going to show you how to link the responses of your form to a Google sheet
0:23
So right now, if you go to the Responses page, which is over here, then you can see you can see the responses of your form to a Google Sheet
0:27
Then you can see the responses in three formats. But the problem with this is that it's difficult to share it with others
0:36
and you can't see all the responses in a systematic way. So to solve this, we can link all of the responses to a Google sheet
0:45
All you have to do is click on link to sheets that's over here
0:51
After that, click on Create a New spreadsheet and you can give it a title if you want
0:57
and then just click on Create. So now it has opened a spreadsheet on a new tab
1:06
and as you can see, the questions and the responses have come here
1:11
And there are two advantages of this. First, this is auto-updating, so every time someone fills in the form
1:18
it will automatically get updated in this sheet. And secondly, you can easily share the responses with others
1:25
If you just click on share on the top right, then like a normal Google sheet
1:31
you can share it with others. The second trick is to get email notifications for responses
1:38
So I'll show you how to do this. First, just go to the responses page again, that's here
1:45
After that, you have to click on the three dots that are here
1:50
So over here, just enable the first option that's get email notifications for new responses
1:58
And now it's enabled. So now every time someone submits the form
2:03
an email will be sent to you on this email ID with which you created the form Then the third trick is adding sections to the form So this form is pretty short
2:14
It just has four to five questions, but let's say you want to create a quiz or a larger form
2:19
with 10 or more questions. Then using sections makes the form a lot more easier to understand and fill
2:26
So now I'll show you how to create that. So let's say, after asking their name, I want to add in other sections
2:33
First, I'll just select this question and then click on this option on the right, which is to add a section
2:43
And as you can see, Section 2 is written here. So on top, it's Section 1, where it's only the email ID and name, and here is the start of Section 2
2:55
So here, you can give any name to the section, and the same way you can create multiple sections
3:01
Additionally, if you want to add conditional logic to the questions, which means that based
3:07
on one person's answer, you can decide which section you want to take them to
3:12
I've created an entire video on that, and again, you can check it out on the top right
3:17
Then the next trick is response validation, and this is something that many people aren't aware
3:23
of, but it's really useful. So what you can do is add parameters to ensure that the responses are correct
3:31
So I'll show you how it works to make it easier. Here, as you can see, I've asked for the email of the person
3:38
But now, people can fill in anything and go to the next question
3:43
So to ensure that they fill in their actual email ID, what we can do is add response validation
3:49
So just click on the three dots that are here. And now select response validation
3:57
And now we need to add what type of response we're expecting
4:01
So since it's an email, instead of number, we'll change it to text
4:06
Then you can change the parameters a bit more. So if you just click on contains then you can decide if you want to add a word which it must contain a word which it shouldn contain an email or a URL So since we expecting an email I just select email
4:24
So now if someone doesn't add the email, they'll get an error
4:28
And if you want to add the error text, then you can just type it out over here
4:33
And now let's quickly see if it works. So here for my email, I'll just add my name
4:40
And as you can see, it's given us this error saying, sorry, please re-enter
4:46
So this is something that you can make use of for emails, for names, for numbers
4:50
whatever you're expecting to ensure that the user puts a correct response
4:55
you can add these parameters. Then the next trick is for people that are making a quiz
5:01
and that's making the quiz autograding. So if you just go to settings, then the first option is to make this a quiz
5:10
And if you enable it, then they've said that you can assign point values, set answers and automatically give feedback
5:18
So this is really useful and can save a lot of time. They also have a few more options like when to release grades and you can just go through all these settings
5:28
So now I'll show you how to add points and the correct answer. So I'll go back to questions
5:34
So here I've asked this question, have you subscribed with the options yes and no
5:40
And what I can do is add the answer key, which is the correct answer, and also assign points for the correct answer
5:49
So just click on answer key that's here. Now just select the correct answer, which is yes
5:56
And if you haven't subscribed, you should now. And now I can add the points here
6:01
So I'll give 100 points for this. And click on done. So as you can see, a tick has come next to yes, since it's the correct answer
6:10
and they'll give 100 points if you answered correctly. So the same way, you can add this for all the previous questions which you've created
6:19
Now coming to the second last trick and that adding collaborators to the form So if you creating a form with others or if you want to share the form with them this will be really useful to you
6:31
Just click on the three dots, which are on the top right here, and then select add collaborators
6:41
And it works really simply, just like how you share a doc with others
6:46
So here, you have to add the email ID, or if you want to share a link
6:50
you can just click on copy Responder link. For now, I'll share the email ID
6:56
After that, you can type a message, and they've also said that editors can view and delete the responses
7:03
So if you're sure you want to give them access, just click on send, and then it will be sent to them
7:09
And if you want to send a link, you can just copy this link and share that as well
7:14
So now, the final trick for this video is how to share a pre-filled link with others
7:20
So usually, when you share a form link, no responses will be filled in
7:25
But if you want to keep some filled in from before, it's really simple
7:29
Just again click on the three dots that are here. Then select get pre-filled link
7:36
So now it has opened the form in a new tab, and you can fill in whatever you want to be pre-filled from before
7:43
So let's say, I want to keep this yes. Then languages you speak English, and now
7:50
I'll just get the link. So scroll down and click on get link then you can copy it
7:56
by clicking on copy link and now you can share it with others. So I'll show you how
8:02
it works I'll open it in a new tab. So here the form has opened so I'll just go to
8:08
the next section. So here as you can see the answers to these two questions
8:15
are already pre-filled. So all that the person has to do is fill in these two, and then they can submit the form
8:24
So this is basically how it works, and if you want to see some more Google form tutorials and tricks
8:30
you can check out these videos over here. That's it for today. Goodbye