G Suite Developers Blog: 4/1/11

G Suite Developers Blog

Information for G Suite Developers

Automate Event Management using Apps Script

April 19, 2011

Editor's Note: Guest author Phil Ridout is an independent consultant specialising in Knowledge Management. He is a facilitator for the Knowledge and Innovation Network (KIN) a business to business knowledge sharing network.Google Apps Script

Create an Events page in the MemberSpace Google Site (in a standardised format)

Create a Calender Event in the Network Events Calendar maintained by facilitators

Announce the event on the MemberSpace news (announcements) page

Allow delegate self-registration

Send attendees a customized email confirmation when they register

Send joining instructions emails to all attendees immediately prior to the event

The Solution

So what’s in the script behind this?Simple Mail Merge1. Event Registration EmailSimple Mail MergeonFormSubmitMail Services2. Event Page in SitesSites Services3. Calendar entry in Events Calendar4. Email confirmation / joining instructions5. Event Announcement in SitesherePosted by Phil Ridout, independent consultantWant to weigh in on this topic? Discuss on Buzz

Google

Labels: Apps Script

Grading Made Easy using Apps Script

April 1, 2011

Editor’s Note: Guest author Dave Abouav is a Google employee who is a part-time instructor for a night class in physics. He created Flubaroo as a 20% time project at Google based on his own teaching experiences.Google Apps ScriptFlubaroo

I wanted to build a simple application which can be easily integrated with Spreadsheets without the need to compile and deploy code.

I liked its ability to integrate right into the spreadsheet as a menu, easily giving teachers access to all of Flubaroo's features.

Apps Script provided UI Services which allowed me to build UI applications very easily from within a browser. I did not have to install complex tools to create a UI.

Apps Script Services makes it very easy to integrate other Google APIs such as Google Charts API for the grade histogram.

A JavaScript syntax is easy to program and without the need to learn more complex languages like Java and Python.

Apps Script gave me the ability to easily share my grading technique with other teachers through the Apps Script Gallery. It is very easy for anyone to install the Flubaroo script in their Apps Script editor.