Pre-filled links in Google Forms – make sorting and filtering a breeze!

Google Forms are a brilliant tool for gathering information from people – the ability to then sort and filter this data in Google Sheets makes it an even more powerful tool.

However, sometimes our users don’t quite read our minds well enough and can give us information in a way that messes with the results we get. A couple of really popular uses for Google Forms is for teachers to get access to students files and also for gathering feedback. You can limit how much typing your user needs to input by using ‘Pre-filled links’. This reduces the opportunity for data to be entered in multiple ways and makes it much easier for you to sort and filter later on.

Use prefilled links in Google Forms to make sorting and filtering easier later! Click To Tweet

Here’s how you can do it:

1. Create a form and think about how you can limit the amount of typing your user needs to do.

E.g, Instead of asking them to enter their homerooms, use a multi-choice list instead.
9TR could be written in numerous ways if your students were to type it in – 9tr, 9Tr, 9tR, 9 t r …..

2. Click on the three dots between SEND and your profile picture. Choose ‘Get pre-filled link’.

3. Fill in the parts that will be the same for each of the users you are sending this to.
4. Once you’ve clicked on ‘Get Link’, the black box at the bottom of your screen will change and you can click to copy the link. Share that link with the users of this Form.

When you go back to the form you’ll see that your pre-filled responses are no longer there. They do not save to the form.

Using pre-filled responses will make it so much easier for you to sort and filter data later.

Sorting and Filtering – brief tips and examples from this form.

Sorting by Assignment

1.Click on the column you want to sort by. In this example I’ve chosen the ‘Assignment Title’ column.
2.Click on the drop down arrow that you see at the top of the column once you’ve selected it.
3.Go to ‘Sort sheet A-Z’ and your assignments will be grouped alphabetically.

Filtering by Homeroom

1. Go to the filter menu and select ‘Create new filter view’.
2.Clear all selected values then choose just one – click OK.
3.You will now only see the information relating to that class. Name the filter view in the space above column A.
4.You can close this filter view and open it again at any time by going back to the filter menu.

If you want to know more about sorting and filtering check out Adrian’s awesome blog post here – he’s made a great video that helps you to understand the difference between the two.

Want to know even more? Check out our online courses here.


How To Use Appointment Slots With Your School

**UPDATED VERSION OF THIS POST available here. The new version of this post includes updated instructions and screenshots.** Appointment slots are a fantastic resource for schools! Appointment slots are great for schools that want to: Manage resources Book rooms Automate the parent / teacher interview sign-up process Anyone who has

VIEW POST

Add a calendar preview to Gmail

The Google Calendar gadget lab gives you a preview of your Google Calendar from the Gmail interface. It can display upcoming events from multiple calendars, and also lets you add new events using the Quick Add feature. You can also choose to show a mini date-picker if desired. The great thing about this lab is that it gives you visibility of your calendar without needing to leave Gmail.

VIEW POST

Augmented Reality In The Classroom

  A few years ago Virtual Reality was making its way into our world.  Now Augmented Reality has taken virtual reality to a whole new level. The best way to explain Augmented Reality or AR is imagine going through life with a layer of technology superimposed allowing a unique blended experience where reality and

VIEW POST
Outclassed Podcast

Fake News and Getting Google Search to Work For You Ep 27

Get Notified Of Future Episodes: Apple Podcasts | Spotify | Google Podcast | Stitcher | TuneIn + Alex | Podcast Addict | Podchaser | Deezer | Listen Notes In this Episode: To see all the OutClassed episodes go to utb.fyi/outclassed Podcast Episode Highlights: Coming Resources and links mentioned: Transcript: Mike

VIEW POST

Here’s What
Our Clients Say

PR Industrya

Client

In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices

Download your skills checklist to see how you score...

 

Sign Up Now
To Get The Latest Updates

 

Holiday Rescue Maker Camp

Student to agree to and tick:
Guardian to agree to and tick: