We’re bridging the gaps in hybrid work with enhancements to Google Meet and the introduction of Spaces. — Read on cloud.google.com/blog/
Posts
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
Google Meet is more secure, easy to use and engaging
Learn about new updates in Google Meet which make it more secure, easier to use and more engaging. — Read on blog.google/outreach-initiatives/education/google-meet-back-to-school-improvements-2021/amp/
Google’s AirTable rival, Tables, graduates from beta test to become a Google Cloud product – TechCrunch
Google’s AirTable rival, Tables, graduates from beta test to become a Google Cloud product – TechCrunch — Read on techcrunch.com/2021/06/14/googles-airtable-rival-tables-graduates-from-beta-test-to-become-a-google-cloud-product/amp/
Apps Script Basics – Range class & triggers (pt 2)
This post continues from the previous post on the Range class and triggers with more examples of how to use it. changing the background colour based on edits to a range sorting a table by multiple columns copying part of a range and creating a new sheet with that range Example 4 – Change cell colour… Continue reading Apps Script Basics – Range class & triggers (pt 2)
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