In Progress

Google Apps Script - one form submit to multiple calendar entries

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

Double Bonus:

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

Skills: Javascript, Software Architecture

See more: the catch of the day, google calendar architecture, google apps javascript, event calendar example, apps scripts google, apps script google, google form scripts, data entry apps, submit to, google apps, google apps scripts, form entry, entries in a day, Apps Script, can create fields google calendar, teacher calendar, google add calendar, script event, session script, multiple fields, day number week, fields google calendar, javascript date fields, data entry form screen, google calendar data entry

About the Employer:
( 18 reviews ) Belmont, United States

Project ID: #5037963