February 2024
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
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
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
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
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
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
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
May 24th, 2022 -Back to the main article
Tags in this post: microsoft, forms, onenote, power automate, student work, self-reflections, solutions
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
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
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
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
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
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
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
September 8th, 2020 -
Tags in this post: Projects, google apps script, javascript, solutions
April 2020
April 1st, 2020 -
Tags in this post: Projects, google apps script, mailapp, images, html, javascript, solutions
March 2020
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
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
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
March 20th, 2020 -
Tags in this post: google apps script, javascript, automation
September 2019
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
November 21st, 2017 -Create Calendar Events Github Repository
Tags in this post: google calendars, google apps script, automation
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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