Skip to content
Richard A. Anderson
Menu
  • Types of Projects
  • About Me
  • Work with me
  • Store
    • Privacy Policy
    • Terms of Service
    • Support

Author: Richard Anderson

Google Sheets / Looker Studio

Looker Studio and Access Control List Tables

The Filter by Email function in Looker Studio Reports is a powerful way of targeting data to the logged in user. However, this assumes a 1:1 relationship between the email …

Google Sheets / Looker Studio

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.

Google Calendar / Google Sheets / Internal Add-on

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 …

Image of Dismissal Tools Features
Google Forms / Google Sheets

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 …

Google Sheets

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 …

Google Calendar

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 …

Google Forms / Google Sheets

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

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 …

Google Sheet
Google Sheets

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 …

Google Calendar

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 …

Posts navigation

Older posts
  • Types of Projects
  • About Me
  • Work with me
  • Store
    • Privacy Policy
    • Terms of Service
    • Support
  • Looker Studio and Access Control List Tables
  • Assessment Tracker with Google Workspace
  • DIY Sign-up Manager
  • Dismissal Tools for Google Sheets
  • Auditing “Shared with Me” Google Drive Files
Stay Connected
Copyright © 2023 Richard A. Anderson – OnePress theme by FameThemes