This is the question that our school’s office manager asked me yesterday as she was working on a room reservation form for our faculty and staff members. We have a few meeting spaces in our school for presentations and workshops, and in the past, faculty and staff members would email her their requests, which we know is not the most efficient method. I was glad to see our office manager working on a new process!
Naturally I posted her question on Twitter, but did not receive any clear cut directions, so I went straight to Google and found this post from Librarians on the Fly! These are easy to follow visual and written directions and they worked like a charm! Unfortunately, in the new Google Sheets, the script gallery has been replaced with the add-on store and the FormMule referenced in the post is not available.
After reading through some posts from the amazing Andrew Stillman in the Google+ community: App Scripts for Education – Builders and Users, I figured out how to take a newly created Google Form and replace the Responses Sheet with an old Google Sheet, so that I could still utilize FormMule.
The Librarians on the Fly solution not only uses form responses to merge to a Google Calendar, it also utilizes the email merge so that one will receive an email whenever a form is submitted. This is a huge timesaver!
Please note: If you don’t feel like doing all of this, another option is to use Appointment Slots, which allows people to sign up for time slots on a calendar, resulting in an email confirmation sent to the calendar owner. Our office manager isn’t sure yet which option she prefers, but both are great alternatives to the “send me an email request” process she was using last year.
Here’s a video showing how I hacked the process a bit to utilize an old Google Sheet to access the outdated script gallery.
[vimeo 100343256 w=500 h=281]