In this post we’re going to look at how to set up a trigger in Apps Script and look at some of the options available. So, first of all, what’s a trigger? A trigger automatically calls a function in the script project based on some kind of event. This could be something changing on a… Continue reading Apps Script: How to automate a script
Author: bazroberts
How to authorize an Apps Script project
In this post, I’ll show you how to authorize an Apps Script project. This could be a project that you’ve written yourself or it could be a program someone else has written and something like Google Sheets has displayed a pop up window asking you to authorize the code. The good thing is that it’s… Continue reading How to authorize an Apps Script project
Mail merge using draft emails
In this post, we’re going to look at creating a simple mail merge program, which will use a draft email as the basis of the final email that will be sent out. The idea is to have a program which is flexible enough to send different messages out and that can be used by admin… Continue reading Mail merge using draft emails
Issues reporting with translation
In this post, we’re going to look at a simple issues reporting system, where the teacher fills out a Google Form to report the issue. This is stored in a Google Sheet, and an email with the summary of the issue is either sent to the maintenance person or IT technician, depending on the type… Continue reading Issues reporting with translation
Enabling hybrid work with Google Workspace | Google Cloud Blog
We’re bridging the gaps in hybrid work with enhancements to Google Meet and the introduction of Spaces. — Read on cloud.google.com/blog/
Multiple FOLDER maker
Making multiple copies of folders in Google Drive is a slow, boring task. You select the folder you want, make a copy, then have to rename it, then repeat this again and again. Here you’ll learn how to create multiple folders and name them individually, really fast using Apps Script. If you’ve already read my post “Multiple… Continue reading Multiple FOLDER maker
Multiple FILE Maker
Making multiple copies in Google Drive is a slow, boring task. You select the file you want, make a copy, then have to rename it, then repeat this again and again. Here you’ll learn how to make multiple copies of a file and name them individually, really fast using Apps Script. First, we have a… Continue reading Multiple FILE Maker
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
Meet – How to present and see the attendees
One of the most common uses of Google Meet is to present something to other people. In this post, we’re going to look at the best way to present. This changed recently with the latest version of Meet and you can now few what you’re presenting AND see who you’re presenting to at the same… Continue reading Meet – How to present and see the attendees