G Suite Developers Blog: Brown University’s IT Dept uses Apps Script to manage Vacation Calendar

G Suite Developers Blog

Information for G Suite Developers

Brown University’s IT Dept uses Apps Script to manage Vacation Calendar

May 26, 2011

Editor’s Note: Stephanie Obodda oversees Computer Training and Communications for Brown University's central IT department. She was on the project team that helped Brown "go Google" in 2010.Brown UniversityThe Solution

Aggregates events from the invited ‘out’ calendar, keeping only the relevant information: person, date, and type of event (from keywords like vacation, sick/doctor, or conference)

Creates a single daily event on another calendar with the day’s “who is out” list. We can overlay this calendar onto our own without having an overwhelming amount of individual “out” events.

Each morning around 9am, the daily Out list is automatically posted on a Google Site.

A single daily event on a shared calendar contains the list of who is out that day.

Code snippet - function which determines the type of event based on keywords in the event title. The keywords were chosen with the help of our HR Manager and several co-workers.Posted by Stephanie Obodda, Brown UniversityWant to weigh in on this topic? Discuss on Buzz