Set The Hook.
Follow me:
  • Home
  • Fishin' Solo Blog
  • MTBoS
  • Table Talk Math
  • The Classroom Chef
  • Would You Rather...?
  • Meet the Fisherman
    • Resume
  • Flipping 2.0
    • Flipping Your Classroom
    • Troubleshooting a flipped classroom
  • Choose Your Own Assessment
    • Student Work Samples
  • Apps In Class
  • Pre-made Math Lessons

One Great Thing: FormMule

10/30/2014

 
Picture
Look closely... This is what "OH YEAHHHH" looks like.
During our Google Teacher Academy Austin chat, somebody tossed out an idea on Voxer about showing people "one great thing" that we do in our line of work.  Most of what I do is the standard run-of-the-mill work that supports teachers and helps them do cool stuff in their classrooms.  We are all doing this in one form or another, so that's nothing special.  There is one pretty cool product that my colleague, Wes Batcheller, and I have come up with:

Request For Training

Before things get too cloudy, I need to give credit where credit is due.  Katie Regan and Kelly Kermode are the geniuses behind what you see in the magical jaw-droppedness that we get to experience.  How does it work?  I thought you'd never ask.
Nothing special, right?  At first glance, it really is just a Google Form, so no, nothing special.  To dissect this a little, I'll break it down:

Name automatically puts the requestors name onto a calendar event that gets created on form submit.

Site automatically gets loaded as the location in FormMule on the event on form submit (we appended it with "High School" to have Google automatically recognize it as an address and get us directions. Some say lazy. We say efficient.

Room Number is nothing special, but it gets added to the notes section of the form submission.

Email Address is there so we can send back an automatic reply with their requested date, time, and a description of what they wanted help with.  Folks like reminders, right?  We have ourselves CC'd on the email so that we receive it in our notifications and can contact the requestor if there is a conflict in the schedule or we need clarification.  Booyah.

Date Requested, Time to Start, and Time to End are all there to create a calendar event in our Google Calendar that we have associated with our tech coach email.  As soon as someone fills this out and submits, a calendar event is created for that date, starting time, and ending time.  Pretty sweet, eh?!

Description of Support Requested is loaded into the notes of our calendar event and also reiterated back to the requestor in the automated email, just to remind them of what they were requesting and give us a heads up as to what's on our calendar.

Here are some screenshots that explain the process of setting up FormMule to work properly with what we are trying to do:
Picture
The first stage in the script (or Add-on) process is setting up the email merge.  We have ours set so that any entry that has something will push a merge, just because the email address is mandatory.
Picture
This part is fun. We have the boxes selected on the lefthand side to turn on the calendar-event merge as well as creating a new calendar event on submission.  We created a separate Google Calendar for all of these requests and input the Calendar ID into the appropriate slot. Using the tags on the right, we made it easy to identify in our new events who the person is, where they're from, what time they want us there, and what they want.  WHABAM.
Picture
A closer look at the tags that we use in the calendar event creation.
Picture
This is our email merge message.  We need to clean this up and offer something a little bit better, but it's 'good enough' for now.  If anything, it drops an email into the requestor's inbox that serves as the much-appreciated reminder that they submitted the form, got validated for doing so, and someone will be there to help.

If you have any questions on how we set this up or would like to chat about it, feel free to get in touch.  Just please don't fill out the form :)

Happy "Making Your Life Easier, One Submission At A Time" Fishing
lazareth link
12/13/2014 08:22:27 pm

Hello,

you said that you where able to created a separate Google Calendar for all of these requests by inputing the Calendar ID into the appropriate slot.

so it creates events on different calendars depending on the request. if so I would like to ask how di you do that.

John Stevens link
1/5/2015 01:23:34 am

Lazareth,

Thank you for stopping by. I should clarify: The script doesn't create a separate calendar for the event. It populates onto its own calendar that we then subscribe to on all of our devices. The benefit is that it is a unique calendar that is only used for scheduling. Does that help?


Comments are closed.

    RSS Feed

    Picture

    Author

    Math nerds tend to have a reputation for being math nerds.  I'm here to continue that trend.

    For more blog posts, click HERE

    Picture

    Archives

    August 2021
    April 2021
    October 2020
    July 2020
    April 2020
    February 2020
    January 2020
    September 2019
    August 2019
    July 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    November 2018
    August 2018
    July 2018
    June 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    November 2016
    October 2016
    September 2016
    August 2016
    June 2016
    May 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    February 2013
    January 2013
    December 2012

    RSS Feed

Powered by Create your own unique website with customizable templates.
Photos from timlewisnm, leppre, KristinNador, Jarosław Pocztarski, Martin Pettitt