Write a simple Google Sheets Script to Create a Calendar Event from Google Sheets.
$10-30 USD
Completed
Posted over 7 years ago
$10-30 USD
Paid on delivery
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.
Dear Sir or Ms.
I am John, pleased to meet you.
I'm well experienced in Google Apps Script and Google Docs.
Please, take a look at my portfolio in my profile.
Can meet all your requirements.
Thank you for your time !
John