Tuesday, December 8, 2015

November 2015 Lunch: Google Apps Scripting

Dan St Pierre came in to talk to us about how his group at LSA has leveraged google apps scripting.

Much of the work they did was related to integrating calendars into an interface that made it easier to schedule and change events. Dan has graciously shared his code, which is attached in the below folder.

Another interesting use was leveraging google scripting within a spreadsheet to make an API call out to MCommunity. Through this script (also attached) a validation is performed against a record in MCommunity and returns a correct email address. From there, the spreadsheet can automatically send an email to recipients based on whether they've scheduled their thesis defense or not.

Dan's code

We'll be taking a break in December for the holidays, but stay tuned for some more interesting topics in 2016!

No comments:

Post a Comment