Here, we’re going to see how we can automatically format rows on a Google Sheet when a Google Form response is submitted. When the form responses come in normally, they have the default format below. But I want them to be formatted as below. So, changing the cell backgrounds to red, only showing the day… Continue reading Automatically format rows for Google Form responses
Category: Sheets
Quickly format multiple Google Sheets with Apps Script
In this post, we’re going to see how we can very quickly format multiple Google Sheets with a little help from Apps Script. The idea of this post, came from the Department of Education in Hawaii, where they have about 300 schools and a guy who works there told me he had to format about… Continue reading Quickly format multiple Google Sheets with Apps Script
How to automate Google Sheets tasks with Macros
Do you get fed up with doing the same monotonous tasks over and over again on your spreadsheets? Well, there’s one thing that may save you time – Macros. These record you doing actions on your sheets, then with a click of a button you can repeat those actions in seconds. Here, we’re going to… Continue reading How to automate Google Sheets tasks with Macros
Card sorting game using Google Sheets & Apps Script
One popular method to get your students to learn is to categorise things or to put them in order. Here, we’re going to look at making a card sorting game, which could be used for both. This is the web app we’re going to make: The code There are two parts to the code, stored… Continue reading Card sorting game using Google Sheets & Apps Script
Forms & Sheets – Attendance System
In this post we’re going to make an attendance system using Google Forms and Sheets. The user will fill in the attendance on the form (possibly on their mobile) and the data will then be stored and organised automatically per student. This will also use a Form add-on called FormRanger to easily populate a Google Form… Continue reading Forms & Sheets – Attendance System
Google Sheets – Grouping rows and columns
Grouping and ungrouping columns Sometimes we have large spreadsheets where we want to work with only certain rows or columns. Sheets gives the option to group rows or columns, allowing you with one click to show and hide numerous rows and columns, rather than having to go into the menus and hide the ones you… Continue reading Google Sheets – Grouping rows and columns
Online exam maker using Apps Script
With all our classes moving from 99% face-to-face to 100% online, we had the situation where we needed to carry out all our exams online too. A relatively easy solution was to use Google Forms, which was easy for students to fill out and for us to receive the answers. The only issue is the… Continue reading Online exam maker using Apps Script
Ladder card game using Google Sheets
Moving to teaching on line has presented some new challenges and one of those has been how to convert some great classroom activities so they can be done on line. One of those is a simple card game where in our foreign language classes, we help students learn new language by printing phrases onto card,… Continue reading Ladder card game using Google Sheets
Parents Evening Appointment System – Part 3
In this final part of a 3-part post (see part 1 and part 2), we’re going to look at how we get the parents form submissions, send them a confirmation email with the appointment details, and record the appointment on the appointment list for the teacher. The main steps are: Get the form responses. Get… Continue reading Parents Evening Appointment System – Part 3
Parents Evening Appointment System – Part 2
This is part 2 of a 3-part post on setting up a parents evening appointment system. Part 1 looked at setting up the documents and in particular the pre-filled form links. Here, we’re going to look at the code which will create the forms for each class and which will create appointment list sheets for… Continue reading Parents Evening Appointment System – Part 2