For the past few months my office has been using a system where we submit a google form to take leave or travel. This form automatically populates a google sheet, and then in turn auto-pops onto a shared calendar. Today it stopped working. I went into the code, and I get the error 'Invalid conference name value (line 111, file "Code"'.
I did some experimenting, and if I change the 'var calendarId' to = my personal email address at work then it posts to my calendar with no problem. If I change it back to the shared calendars address it gives the error.
At this point I don't think my code is broken, I feel like my agency (gov't) has limited my ability to use code to post to a shared calendar. Am I missing something here? Any thoughts appreciated. Thanks!
/**
* Creates an event in the user's default calendar.
*/
function createEvent(title,startDt,endDt,desc,loc, col) {
var calendarId = 'THIS IS WHAT IS CAUSING THE PROBLEM';
Logger.log(typeof(startDt))
var start = new Date(startDt);
**var startISO = start.toISOString();**
var end = new Date(endDt);
var endISO = end.toISOString();
var event = {
summary: title,
location: loc,
description: desc,
start: {
dateTime: startISO
},
end: {
dateTime: endISO
},
// Sets the calendar color
colorId: col
};
event = Calendar.Events.insert(event, calendarId);
Logger.log('Event ID: ' + event.getId());
}
So this morning I come in, ad I no longer get the invalid error from last week. Now I'm getting a new error, 'RangeError: Date is invalid. (line 95, file "Code")
