We have an existing form that does two things; it sends an email to our ticket system, which creates a ticket, and creates a Google calendar event.
The Google Form stopped working. The drop down menus and calendar widgets do not work.
In addition, events that started at 12 Noon stopped being able to be submitted a few moths ago.
You can see the form at: https://script.google.com/a/macros/marymount.edu/s/AKfycbwh-CpVDoSm_hRjndISnYksFuIvmfnXj9LfqS7Mx2r6UzKxPQo/exec
You can see the script at:
You should be able to see the code with this link. Please tell me how quickly the form can be working again.
It gets the rooms and equipment from this Google Sheet:
We had an issue with time handling that was previously corrected using this sheet to try to correct the Daylight Saving Time Issue.
The form is is live, so please, if you create any test events, put them on December 25, 2016 only so I will know to delete them.
If there is a way to see a log of email addresses (or other identifying data) of those who have attempted to use the form for the last few weeks, that would be very helpful. The form was not working but users may not have realized it. We need to contact them.
If you can get the form working, we would like to hire you for some small improvements to it.
Thanks for your help!