Data Studio and Access Control List Tables
The Filter by Email function in Data Studio Reports is a powerful way of targeting data to the logged in user. However, this assumes a 1:1 relationship between the email …
Assessment Tracker with Google Workspace
The Assessment Tracker Add-on for Google Workspace is now available for install in the Google Workspace Marketplace. Contact me to set-up your free trial.
DIY Sign-up Manager
If you host a lot of free virtual events, managing registrations and sending calendar invites can quickly become an administrative nightmare. With some help with a little Apps Script we …
Dismissal Tools for Google Sheets
While my Google Sheets Add-on, Dismissal Guru, goes a long way in facilitating school dismissal workflows. I also build custom solutions for schools. These are essentially more robust versions of …
Auditing “Shared with Me” Google Drive Files
The “Shared with Me” space in Google Drive can feel overwhelmingly chaotic and even anxiety inducing if you have the desire and need to organize everything in Google Drive. Here’s …
Color Code my Google Calendar!
Chances are if you’ve managed to get your teaching schedule on Google Calendar it might look something like this. This works for some, but others may prefer to further group …
Let me get that QR Code for you!
QR Codes are amazing little bridges that connect our physical world to our digital one. It’s so much more practical scanning a QR Code, than typing in a full url …
Google Calendar and Webcal Feeds
UPDATED: 08/27/2021 I’ve updated the public app to handle larger jobs now. Approximately 3 years ago I wrote a post on using Apps Script to copy events from a calendar …
Generating Unique PIN numbers in Google Sheets
Sometimes a need arises for creating, multiple random unique ids. When I created our Google Forms-based dismissal workflow, I needed to generate unique PIN numbers for every student. Here was …
Bulk Delete Specific Google Calendar Events
For many of us, we rely on Google Calendar to help us structure our work days. It does a lot of things really well, but one limitation is the ability …