jordan rhea wearing a hoodie
Written by jordan rhea Building tools and connecting systems

February 2024

Turn Cells Into Notes

February 6th, 2024 -Turn a range of cells into notes without spending all day clicking!

Tags in this post: Projects, google apps script, javascript, solutions

February 2023

Activate Your Cells

February 7th, 2023 -I was getting annoyed with a spreadsheet that I use to track gym sessions. Getting the screen to focus on the correct cell was not working…

Tags in this post: Projects, google apps script, google spreadsheet, javascript, solutions

October 2022

Cascading a PowerSchool Schedule

October 27th, 2022 -PowerSchool has a super extensive customization system, however learning how to use it effectively takes a considerable amount of overhead…

Tags in this post: powerschool, customization, scheduling, google apps script, solutions

June 2022

Approved By Who?

June 13th, 2022 -Have you ever needed a document signed, walked across the campus and the signer was off at lunch? What if there was a way to get these kinds…

Tags in this post: microsoft, forms, power automate, power platform, solutions

May 2022

Split Keyboard Layout

May 27th, 2022 -Fixing the elbow and wrist pain for me was as simple as changing my keyboard. I have been using the ErgoDox EZ since 2020. It has helped me…

Tags in this post: keyboard, programming, qmk

Group by Month - Website update

May 25th, 2022 -My current goal is to continue to post some parts, demos, and other miscellaneous documentation of some of the many projects that I have…

Tags in this post: typescript, react, web development, solutions

Tagging Images in a Document Library

May 25th, 2022 -Creating a tagging system in a document library Much easier than you might think. With the modern iteration of Sharepoint Lists, it is as…

Tags in this post: solutions, microsoft lists, sharepoint

Student Reflection Form Example

May 24th, 2022 -Back to the main article

Tags in this post: microsoft, forms, onenote, power automate, student work, self-reflections, solutions

Automated Student Self-Reflections

May 24th, 2022 -The greatest trick of saving time is gathering information effectively Whether it is how you are collecting their homework, assessments, or…

Tags in this post: microsoft, forms, onenote, power automate, custom connector, PowerSchool, student work, self-reflections, solutions

September 2021

Organize those Organizational Emails

September 16th, 2021 -So you have convinced your organization to move those large organization wide emails over to Sharepoint and build a network of sites that…

Tags in this post: solutions, microsoft outlook, inbox zero

June 2021

Once is already too many

June 11th, 2021 -When using Microsoft Lists I am often running into a situation where I need to copy information into or out of a list. There are a bunch of…

Tags in this post: Projects, google apps script, javascript, solutions

Shoot your best screenshot

June 11th, 2021 -There are tons of extensions available for accomplishing all kinds of tasks in Chrome browser. However, sometimes you don’t want to install…

Tags in this post: Projects, google apps script, chrome browser, javascript, solutions

May 2021

SPFx Tricks I Learned

May 28th, 2021 -Update SPFx dependencies to 1.12.1 from 1.11.0 Very simple process, but I had to scour the web for a few things before I got it right…

Tags in this post: Projects, javascript, typescript, solutions

Gantt Charts with Microsoft Planner

May 24th, 2021 -Horizontal and vertical planning with Gantt Charts In our office we are using Microsoft Planner to keep track of the projects and tasks that…

Tags in this post: Projects, google apps script, javascript, solutions

January 2021

Introduction to Sharepoint

January 11th, 2021 -Microsoft Sharepoint has been the name of the game for the past 4 months. I started with almost nothing to use as context. SPFx Dev Youtube…

Tags in this post: microsoft 365, javascript, typescript, sharepoint, lists, office 365

September 2020

Parsing a PDF to CSV

September 8th, 2020 -

Tags in this post: Projects, google apps script, javascript, solutions

April 2020

Emailing with Inline Images

April 1st, 2020 -

Tags in this post: Projects, google apps script, mailapp, images, html, javascript, solutions

March 2020

Fun with Cloud Functions

March 28th, 2020 -Cloud functions! Easy way to process HTTP requests without setting up an entire server. Plus they are cheap! Plus you can use any language…

Tags in this post: Projects, google apps script, javascript, solutions

Covid-19 Query Time

March 25th, 2020 -More problems have arisen! They changed the format of the CSV files in the Github Repository. Gee whiz! Well that is something that we can…

Tags in this post: Projects, google apps script, javascript, solutions

Update Sheet from Remote CSV Files

March 24th, 2020 -We already pulled some data from a CSV file stored on Github. Now we need a way to update this. Here is a down and dirty implementation of…

Tags in this post: projects, google apps script, javascript, solutions, csv, google sheets, github

Google Classroom API Builder

March 20th, 2020 -

Tags in this post: google apps script, javascript, automation

September 2019

Building a Data Studio Connector with Apps Script

September 17th, 2019 -Creating data studios is a pretty awesome way to create data visualizations. However, if the connectors don’t already exist, you have to…

Tags in this post: Projects, google apps script, javascript, solutions, data studio

June 2019

The Havel-Hakimi algorithm for graph realization

June 12th, 2019 -Project originally posted on reddit.com/r/dailyprogrammer It was a dark and stormy night. Detective Havel and Detective Hakimi arrived at…

Tags in this post: Challenges

Print a new number by adding one to each of its digit

June 6th, 2019 -Project originally posted on reddit.com/r/dailyprogrammer Description A number is input in computer then a new no should get printed by…

Tags in this post: Challenges

The Revised Julian Calendar

June 6th, 2019 -Project originally posted on reddit.com/r/dailyprogrammer Background The Revised Julian Calendar is a calendar system very similar to the…

Tags in this post: Challenges

Shunyi Today

June 5th, 2019 -Shunyi Today is my first attempt to scale out a full-stack graphql application. I started with the brand new Wes Bos course Advanced React…

Tags in this post: Portfolio, Web Development, GraphQL, Projects, solutions

Axis-aligned crate packing

June 5th, 2019 -Project originally posted on reddit.com/r/dailyprogrammer Description You have a 2-dimensional rectangular crate of size X by Y, and a bunch…

Tags in this post: Challenges

Looking at the Data!

June 4th, 2019 -I wanted to take a look at the responses to the Game of Thrones data I got back in my Game of thrones season 8 bracket so I thought there…

Tags in this post: Projects

Keystone Calendars

June 3rd, 2019 -A year and change ago I wrote some code that would help synchronize a 6-day calendar with a 5 day week. The goal is to remove the paper…

Tags in this post: Projects, javascript, office 365, twitter bootstrap, outlook calendars

May 2019

Build a Find and Replace function in Google Sheets

May 21st, 2019 -There are simple ways to find and replace in a spreadsheet built right into Google Sheets. And in Excel for that matter. What happens when…

Tags in this post: Projects, google apps script, javascript, function, map, reduce

April 2019

Brackets are Coming

April 12th, 2019 -Winter is here and brackets are coming! If you are like me, you lost your NCAA bracket. But that isn’t the end for aspiring bracketologists…

Tags in this post: Projects, javascript, solutions, pdf, document flow

March 2019

Build a Dokku Server and Deploy a GraphQL Stack

March 5th, 2019 -The new Wes Bos course is called “Advanced React and GraphQL” and I can’t leave out a shout out to how much I enjoyed going through the…

Tags in this post: Projects

February 2019

Writing Poetry for Friends

February 22nd, 2019 -The second annual Sinterklaas Gift Exchange with some friends in Beijing. I couldn’t bring myself to write a bad poem, so instead I made a…

Tags in this post: Projects

What is a 6-Day Schedule?

February 20th, 2019 -Building an Office365 Calendar Tool on a 6-Day School Cycle When this project was first proposed to me, I had a hard time figuring out what…

Tags in this post: Projects

Comment Harvester ... At Long Last!

February 8th, 2019 -Pull all of the feedback you have given your students in a Google classroom and visualize it with Google Sheets

Tags in this post: Projects, google sheets, google classroom, javascript, custom function, zillow, integrations, solutions

Build a Zillow Pricing Custom Function

February 7th, 2019 -There are tons of ways to incorporate data from external services into your spreadsheets. is a good example. Good news! It is easy to roll…

Tags in this post: Projects, javascript, custom function, zillow, solutions

March 2018

New Innovator Dashboard

March 27th, 2018 -​ If you are using a modern browser, chances are you are using some kind of extension for it. In this video I am just demo-ing a browser…

Tags in this post: Projects, Web Applications, Teacher Tools, Work Tools, web app, google sheets, chrome browser, chrome extensions, needs update

Google Forms Are Boring

March 20th, 2018 -Google Forms… YA BORING! But not for long! In this demonstration I am taking the input from a form and adding back into the form. There isn…

Tags in this post: Projects, google forms, html, coding, dynamic, drop-downs, feedback

January 2018

Star Wars Crawl with Google Docs

January 12th, 2018 -Happy 20-INNOV-18 everyone! My first project of the year is a modification of a great Codepen project that recreates the Star Wars title…

Tags in this post: Projects, star wars, title crawl, google docs

November 2017

Adding Rows to a Sheet from a WebApp

November 29th, 2017 -A great community suggestion from John Galla in the comments of a previous video! ​ The file is simply: Then, on the front-end of your…

Tags in this post: Projects, javascript, coding, web apps, dopost trigger

Holiday Gift Exchange

November 28th, 2017 -It is the holiday season and I want to share a fun way to engage your students with the spirit of sharing! ​ Many customs and cultures…

Tags in this post: Projects, gift exchange, secret santa, google forms, google apps script

Create Calendar Events

November 21st, 2017 -Create Calendar Events ​ Github Repository

Tags in this post: google calendars, google apps script, automation

The Properties Service

November 21st, 2017 -Another dope idea from the yearbook guru @jentechnology. ​ I noticed that she was asking about a better way to store notes inside of a…

Tags in this post: Projects, properties service, dynamic data, google slides

Insert From Drawings

November 10th, 2017 -During the #GoogleEI twitter chat, an idea was proposed and I couldn’t help but give it a try. ​ Thanks to @jentechnology for the great idea…

Tags in this post: google apps script, google drawings, google slides, community suggestions, features

October 2017

Stranger Things

October 24th, 2017 -It is almost time for Stranger Things Season 2! What better way to celebrate than to turn a cool codepen into a review game. ​ I wanted to…

Tags in this post: stranger things, codepen examples, google apps script, the upsidedown, tv addiction

Digital App Dice

October 20th, 2017 -App Smashing is a cool way to integrate several apps into a one project. In this project we are building digital dice to add a randomness to…

Tags in this post: Projects, app smashing, google apps script, google innovators, collaboration, teacher tools, innovator project

SASSy Styles with the Create React App Tool

October 14th, 2017 -The create-react-app CLI tool is an incredible way to get started with ReactJS. ​ If you have ever started a react project in the past you…

Tags in this post: sass, scss, styles, cli tools, create react app

Classroom Twitter

October 13th, 2017 -What if it was possible to have students send tweets about the classroom without having every student sign up for a twitter account? What if…

Tags in this post: Projects, twitter api, google apps script, google classroom, teacher tools, activities

Sharable Link Trigger

October 12th, 2017 -Sometimes you want to share a document with an entire class and let everyone have edit permissions. However, what if you want to revoke…

Tags in this post: Projects, triggers, link sharing, google apps script, automation, properties service

The Calendar and the Date Object

October 2nd, 2017 -I love when people suggest things for videos… even when they aren’t teachers! I made this channel to inspire teachers to think of ways to…

Tags in this post: Projects, javascript, google apps script, google calendar, dates, date object

New Google Slides Service

October 2nd, 2017 -Google Apps Script now provides a simple way to integrate with slide decks! ​ One of the problems that I am noticing is that there are no…

Tags in this post: Projects, google apps script, classroom roster, google slides, presentations

September 2017

Summer Vacation Map

September 26th, 2017 -This is a project that I built for a part of a demo slam with Ceci Gomez-Galvez at the Shekou Summit. This is a longer project that I…

Tags in this post: Projects, google apps script, google maps, teacher tools, collaboration, summer vacation, feedback, visual

Apps Script Boilerplate

September 21st, 2017 -In one of my youtube Projects I demonstrated how to link your apps script editor with your github account and I used this repository. ​

Tags in this post: Projects, google apps script, boilerplate code, code sharing, github, needs update

Multi-DropDown DataValidation

September 20th, 2017 -Updated on Oct. 22nd 2018! ​ I have finally updated this add-on due to getting tons of messages about it having stopped working in the…

Tags in this post: Productivity, Portfolio, Projects, google apps script, data validation, dropdowns, google sheets, needs update

Cart Scheduler

September 20th, 2017 -This idea is for Stephanie Fillardo, who wanted to use apps script to make it easier for teachers to reserve the tech carts in her school…

Tags in this post: Projects, google apps script, google forms, javascript, coding, scheduling, automation

Autocompleting Documentation

September 17th, 2017 -How can you create those cool autocompleting popups on your custom functions? In this video I am explaining how to build them for yourself…

Tags in this post: Projects, autocomplete, documentation, javascript, google apps script, google sheets

Return JSON with ContentService

September 17th, 2017 -Javascript Object Notation is one of the most common formats for sending data over the internet. ​ If you are building any sort of…

Tags in this post: Projects, json, javascript, coding, contentservice

The Goodreads API in a Custom Function

September 17th, 2017 -Do you ever keep lists of books for your students on Goodreads? In this video I am showing how we can write a custom function to get data…

Tags in this post: Projects, github, urlfetchapp, custom functions, google sheets, goodreads api

Use Codepen to Layout your HTML and CSS

September 17th, 2017 -When you aren’t a designer it can be difficult to create a good looking interface for your users. And despite what you think, it matters to…

Tags in this post: Projects, coding, codepen, html, css, layouts, google apps script

Version Control your Apps Scripts with Github

September 17th, 2017 -Social media isn’t just for sharing pictures with your friends. Developers can even share code with their friends! ​ In this video I am…

Tags in this post: Projects, github, version control, code sharing, teacher tools, needs update

Installable Triggers

September 15th, 2017 -How to use installable triggers with Google Apps Script. ​ This project is based on a Google Form about a club signup. These kinds of…

Tags in this post: Projects, installable triggers, google forms

Instant Feedback

September 15th, 2017 -Providing feedback is an important part of teaching. However, it can be hard to manage when you have a classroom full of students requiring…

Tags in this post: Projects, google apps script, feedback, google sheets, onedit trigger

HTML Templating

September 15th, 2017 -When you are coding with Google Apps Script you don’t always have to hard code all of your data into every page. There is a decent…

Tags in this post: Projects, html templates, javascript, coding, google apps script

Contact Form

September 15th, 2017 -Create a contact form on your website hosted on a static site. ​ When you have a cheap shared server package from one of the giant hosting…

Tags in this post: Projects, html, google forms, google apps script, javascript, coding, contact form

Library Genre Quiz App

September 13th, 2017 -This is a tool suggested by my third favorite librarian in the entire world, Liz Brouwer! She wanted a way to help students find books in…

Tags in this post: Projects, library, google apps script, dashboards, needs update

Slides2Drive

September 13th, 2017 -This tool was the brainchild of my friend Dee Lanier. He wanted a way to take all of the slides from a slidedeck and save them onto drive as…

Tags in this post: Projects, google slides, google apps script, presentations, automation

Caption Creator for Google Drive

September 13th, 2017 -This project was born from the brain child of Melissa Oliver and her passion project, to create accessibility in classrooms. ​ Teachers do…

Tags in this post: google apps script, productivity, teacher tools, Portfolio, google drive, google docs, accessibility, javascript, video

ClassDojo Chrome Extension

September 13th, 2017 -I love ClassDojo and so do primary students! In this project my goal was to make it easier for me to track attendance data from ClassDojo in…

Tags in this post: Teacher Tools, Data Automations, Portfolio, gmail, chrome extension, javascript, extensions, google apps script, classdojo

UBD Unit Planner

September 13th, 2017 -Ever had a document template that you had to repeat every few weeks and that were very different, but also similar? This was a project I…

Tags in this post: Projects, google docs, google apps script, lesson planning, unit planning, unit by design, needs update

Wonder Wall Display

September 13th, 2017 -The Digital Wonder Wall was the brainchild of myself and Dan Sharpe, another innovator and fellow coder. ​ We were both learning about how…

Tags in this post: Projects, student feedback, teaching tools, instant, active, inquiry based learning

Contact Creator

September 13th, 2017 -Contact Creator was a tool suggested on the Apps Script for Education forums. I am still working on the “Student Data Portal” from a…

Tags in this post: productivity, portfolio, projects, google classroom, feedback

Easy Grader

September 13th, 2017 -Entering student marks… the easy way! Have you ever spent 5 hours marking work, and then realized it was going to take you another 4…

Tags in this post: Projects, teacher tasks, teacher tools, google apps script, google add-ons, needs update

Drive Title Copier

September 13th, 2017 -A colleague had a ton of student work that she needed names in the titles. She had the fear that she would have to open each document and…

Tags in this post: Projects, google drive, automation

Email Summarizer

September 13th, 2017 -This project was suggested by Desiree Alexander who felt that she was getting too many emails from various groups that she was involved with…

Tags in this post: Projects, data manipulation, gmail, automation, needs update

Google Innovator Academy Dashboard

September 13th, 2017 -I was accepted into the Google Innovator Academy in May of 2016 as part of the #COL16 cohort. Since my project has been all about using…

Tags in this post: Projects, google developers, google innovator, chrome browser, chrome extensions, productivity, dashboard, needs update