I try to create a simple list in GScript from all my recurrence dates in GCalendar. Currently, all appointments are displayed. However, I would only list the initial appointment with the appointment data: subject, appointment time, appointment end, interval.
Does anyone have a scriptexample wo can this explain my mistake in the script?
Many thanks
function Stackoverflow() {
var calendarId = CalendarApp.getId();
var calendar = CalendarApp.getCalendarById(calendarId);
var events = calendar.getEvents(new Date(1901-01-01), new Date('2099-12-31'));
var spreadsheet = SpreadsheetApp.create('MyCalendar');
var sheet = spreadsheet.getSheets()[0];
sheet.appendRow(['Subject', 'Start', 'End', 'Intervall']);
for (var i = 0; i < events.length; i++) {
var event = events[i];
if (event.isRecurringEvent()) {
var startDate = event.getStartTime();
var endDate = event.getEndTime();
var myPeriod = event.isRecurringEvent().valueOf
sheet.appendRow([event.getTitle(), startDate, endDate]);
}
}
Logger.log('Tabelle erstellt: ' + spreadsheet.getUrl());
}