Write a simple Google Sheets Script to Create a Calendar Event from Google Sheets.
该项目成功由ioanaprof ，以 $25 USD的价钱在 天内完成。为像这样的项目获取免费报价
项目预算$10 - $30 USD
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.
- The New York Times
- Wall Street Journal
- Times Online