#EdTechCalNYNJ Workflow & Creation: How to automatically merge form data to a calendar!Thursday, April 16, 20155:51 PM
I wrote about the creation of #EdTechCalNYNJ yesterday (selfish plug: http://tinyurl.com/edtechcalnynj), and today I want to write about the workflow to create the site. I like the idea of documenting workflows. Hopefully it will be interesting to anyone who wants to use or adapt the functionality, and at like most everything on this blog, it helps me process my own work for reflection.
- I wanted to use a Google Calendar so people could add events to their own calendars
- I wanted to use a Google form and add-ons to manage the automation
- I wanted to leave everything public and collaborative, but still needed the ability to administer and edit
- I wanted to be able to give contributers credit for their ideas and events
- Create a new calendar. This was easy. I created a new calendar in Google Calendar, made it public, and found the address in settings.
- Install Old Form Mule. Form Mule is a wonderful mail merge add-on that automates e-mails based on form results. The old version, in scripts, also allows for a Calendar merge. With this script, I automated e-mails to the site admins notifying us of new additions, and automated calendar merges. We thought about added an approval/moderation feature, but it seemed to be more trouble that it's worth. Keep it open and public but we still have admin rights to change the calendar.
- Copy Down. Form Mule wants the date for the calendar event to be in the Date Time format, so I used Copy Down to combine this data into the add-on-friendly format. Every time a form result is submitted, any code copied to cells gets pushed down, adding a new line of data. Copy Down is great because it lets you copy formulas to organize and manipulate new data.
- Form Router. We wanted to be able to credit contributors by listing their contact info. The obvious was to do this was to pull data from the form results, but it's hard to manipulate in the sheet. Form Router helped by appending form results to second Google Sheet in real time. We could manipulate data, add links to contact info, and publish it without messing up the form results.
- Google Site. Lastly, we built the Google Site for #EdTechCalNYNJ. This was easy! The calendar, contributor page and form were all seamless to embed. Piece of cake!