Have you ever had a student type in their name or ID number incorrectly into a Google Form? Or select the wrong teacher or class period from a drop down menu? There is a little known feature in Google Forms that allows us to pre-fill answers for our students. No more wrong ID numbers or misspelled names.
How great is that?!
It’s almost like magic. For real...
Let’s see what this actually looks like. First, check out this sample form. Nothing special here, just a normal Google Form.
Now open the sample spreadsheet with pre-filled links spreadsheet and click on one of the pre-filled links in column A. This is the exact same Google Form, but now you see some questions are pre-filled already. Go ahead, click on all the students to see how it does it for all of them!
See the magic?! So now that you know what pre-filled links do, you want to know how to make them. Wait, did I just read your mind? Maybe I’m magic too....
Here are the basic steps and a Youtube video I made if you prefer to watch the instructions:
Answer all questions for the pre-fill in capital letters with no spaces. This makes it easier to find for cell referencing. You will also replace the pre-filled answer with “&cell&”. For example change STUDENTLASTNAME to “&A2&”. Then you will reference all the cells you have pre-filled answers for.
It is also helpful to use the =HYPERLINK formula to shorten link and aid with spaces in any pre-filled answer.
Now that you can generate and share pre-filled links, let’s talk about ways we can use them. Here are some of ideas:
What other ways do you use or can imagine using Google Forms pre-filled links?
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.