Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Easy! Google Forms: Automatically Sort on Submit

When a Google Form is filled out, you may want to automatically have the new response sort to the top.

Easy! Google Forms: Automatically Sort on Submit

Sort Your Google Forms Results Automatically

Google Forms is amazing, however it can be challenging to read Google Forms submission in a spreadsheet sometimes. You may need to make the columns wider, set word wrap, hide some columns, etc… The problem is that when you format your spreadsheet or sort your data any new form submissions do not have the formatting. You can easily fix this problem in 2 easy steps.

Step 1: Macros

After you get a couple of form entries, go to the spreadsheet of responses. Use the Extensions menu to choose Record macro. Set word wrap, sort a column, make rows taller, etc… whatever you would like to do to format the spreadsheet.
Record Macro

Save your macro.

Note: Google Sheets has been updated. You will now find the Macros under the “Extensions” menu.

Step 2: Set up a Trigger

Don’t let this step intimidate you. It might look scary but it’s really fairly easy. Use the Extensions menu to choose Apps Script. You will see the code that was created from your recorded macro. You do NOT need to read or do anything with the code.

On the left side of Apps Script click on the clock, selecting Triggers.

This will launch the script hub for Google. Notice in the bottom right is a button to “Add trigger.” Click on this.
Add trigger to a google sheets

You will check 2 things on the trigger creator. For the first drop down box you want to make sure it is using the function for the macro you recorded. It will be what you named the macro but smashed together with no spaces. On form submit

The second thing you want to check is the last option “Select event type.” From that drop down menu you want to choose “On form submit.” So when the form is submitted, it triggers running your macro.

Save! That is it! From now on when a new form submission comes in your spreadsheet will be sorted and formatted how you like it!

Want to Learn More?

This activity is a very simple way to get into coding Google Apps Script. Essentially no coding required but you get to see the code behind the curtain. If you’re ready to take the next step to learn how to make your own code try one of my online coding workshops.

Want More Help with This? Become a Premium Member

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.