Forms Archives - Teacher Tech

Easy! Google Forms: Automatically Sort on Submit

by admin | Dec 13, 2018 | Advanced, Apps Script, Forms, Google, Sheets

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...

Code a Google Calendar Event from Google Forms

by admin | Dec 8, 2018 | Advanced, Apps Script, Calendar, Forms, Google

Code a Google Calendar Event from Google Forms For my Coding Google Forms workshop I thought it would be super easy to make a tutorial on how to have people sign up for something on a Google Form with a Date and Time and then create a Google Calendar event. It is easy...

Google Docs is NEW!!

by admin | Oct 28, 2018 | Advanced, Docs, Forms, Google, Sheets, Sites, Slides

Try Dot New with Your Google Apps There is a new way to create your favorite Google App. End it in dot new. doc.new docs.new sheet.new sheets.new spreadsheet.new form.new forms.new slides.new slide.new site.new sites.new Control T I love an excuse to get in a tip to...

Google Forms: One Form for All Periods

by admin | Oct 16, 2018 | Advanced, Forms, Google

Do Not Make Copies The paradigm shift of using Google Apps is you do not make copies. Having multiple documents with the same name makes a mess of your Google Drive. You manage versions. However, with Google Forms there is no version history. If you are a teacher of...

Google Forms Column to Google Slides

by admin | Sep 4, 2018 | Advanced, Forms, Google, Sheets, Slides

Send a Column of Responses from Google Forms to Google Slides Google Forms is awesome but can be tricky to go over responses with the class. I coded an Add-on for Google Sheets that will allow you to select a column of responses from a Google Form and send those...

REUSE Not Copy Your Google Form

by admin | Aug 3, 2018 | Advanced, Forms, Google

Reuse Google Forms As we start a new school year we probably have a bunch of Google Forms we used last year. Google Forms are the best thing since sliced bread but I don’t want them clogging up my Google Drive with copies. DO NOT MAKE COPIES! A paradigm shift...