I need a script that upon a form submittal (see attached) that has multiple date fields, for each date it will create a calendar entry with an appropriate event title. Basically, the user enters information about a class, including class id, teacher, location, number of sessions, and the dates and topic for each session. Upon submittal, I want a calendar event created according to for the format shown in the screen shot (including repeating the location in both the location field and in the event title).
* If we were to add a "Day of Week" field, validate that the entered dates are on the correct day of the week.
* Count the Number of Sessions and validate that the user did, in fact, enter the correct number
Update the calendar if the original form is edited
Update the form entry if the calendar is edited
(Or at least somehow catch and warn about data inconsistencies)
If you can do this project, please specifically specify that you have worked with google scripts and give a reference example.
Also, please specify which bonuses, if any, you intend to complete