I have a Google Form that I am trying to write a script in Google Sheets to automatically populate an AllDayEvent in my Google Calendar. This should be VERY simple. I am not a coder. I found some code online that worked sometimes, but it does NOT work every time. I can supply this code and the form as a basis but here is what I am looking for.
My Google Form has many fields, but I want to create a date using the following:
Date: "NextActionDate" (for an All Day Event)
Text Field 1: "NextAction" to be used as title
Text Field 2: "Customer" be used as meeting location.
This should be triggered by each form submission.