In this post, we’re going to look at how we can quickly make short bit.ly links for pre-filled Google Forms using Google Sheets and a bit of Apps Script. Bit.ly links are great but if you have to make a lot of them in can be a slow, tedious process. Plus, if you also want… Continue reading How to quickly make short pre-filled URLs
Google Workspace Tutorials
Apps Script: How to automate a script
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
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