Now, Region One Staff can look at both calendars, for iPad Cart 1 and iPad Cart 2 and see when there is an opening. Then, they can fill out the form and the dates are automatically entered into the shared calendar so I and my co-workers don't have to manually input the reservation. The person filling out the request receives an email confirmation for the reservation and I receive an email letting me know that the reservation was put on the calendar.
A miracle you say? Yes, now I have 3 calendars that run themselves and allows the staff to see when there are openings.
So here is how I did it......
First I created the calendar.
Second, I created the form making sure that I had all the information I needed, including the date the COW was needed and the date the COW would be returned.
Next, I had to work with the Response Spreadsheet to set up the Email and Calendar merges. The Script that has to be installed is called FormMule. You find scripts under the Insert Tab, then scroll down to where it says scripts. When you search, make sure FormMule is typed in as one word.
Now, you will need to install the FormMule. After you install, it FormMule will ask for authorization to run.
I can't tell you how awesome it feels to have this system up and working. I had a fellow Google fanatic here at work that helped me sort all of this out. Thank you Efren!!!
I have used this for Air Card Checkouts and COW checkouts. Can you think of ways to use FormMule? Tell us about it!