Saturday, September 5, 2015

Calendaring Weird Schedules with formMule


It’s that time of year when I build the schedules for my school in Google Calendar. My school uses a six day cycle (A,B,C,D,E, and F) which does not conform with Google Calendar well. This system allows you to use an unusual schedule to fill in a Google Calendar for the year. Each year I try to rebuild systems like this to make them a little better. In this case I’ve updated the dates, cleaned up some of the functions, added a directions sheet, and most importantly, used the new formMule script that’s built into the new sheets. Another big shout out to +Andrew Stillman and the New Visions Cloud lab team, without them this would not be possible.


This system requires some set up and I’ve tried to make it easy to play along. Please let me know how I’ve done. You can make a copy of a clean sheet by clicking here. From this point on I will be linking to a demo sheet that is already set up.


By default, the sheet is prepared for a six day cycle, though you can create any cycle by customizing column “A” of the “Teacher Schedule” Sheet. Next, you have to update column “D” of the “Day Cycle” sheet. I recommend adding your holidays first (delete mine) and then work your cycle around them. The rest of the set up is outlined step by step on the directions sheet. This demo sheet was used to create this calendar.

This system works well for me; I use it on the elementary level to create special area schedules (PE, Art, Music, etc.) That said, it might not fit your needs. You might also want to look at the inspired work of Christopher Webb. His Google Calendar Import Tool is nothing short of amazing. There’s also a rumor going around that James Peterson is working on an add-on for this kind of thing. I am eagerly anticipating that! Please let me know if you use this system, find a bug, or can think of a way to make it better.

1 comment:

  1. Hello! Do you perhaps have an 'updated' sheet to make this workflow work? I am getting an error saying "UiApp has been deprecated. Please use HtmlService instead" Thank you!

    ReplyDelete