【GAS】Googleカレンダーに曜日を指定してスケジュールを登録するスプレッドシートの構築

1
function initializeSheet(sheetName=SHEET_NAME_12TH){
2
  const rangeName01 = RANGE_NAME_IN_SHEET_12TH_TO_INPUT_MANDATORY_ITEMS;
3
  const rangeName02 = RANGE_NAME_IN_SHEET_12TH_TO_INPUT_DAY_OF_WEEK;
4
  const rangeName03 = RANGE_NAME_IN_SHEET_12TH_TO_INPUT_OPTIONAL_ITEMS;
5
  const rangeName04 = RANGE_NAME_IN_SHEET_12TH_TO_LIST_COLOR_INDICES;
6
  const ss = SpreadsheetApp.getActiveSpreadsheet();
7
  const sheet = ss.getSheetByName(sheetName);
8

9
  ss.setNamedRange(rangeName01, sheet.getRange("A1"));
10
  ss.setNamedRange(rangeName02, sheet.getRange("A5"));
11
  ss.setNamedRange(rangeName03, sheet.getRange("A9"));
12
  ss.setNamedRange(rangeName04, sheet.getRange("A13"));
13
  sheet.getRange(2, 3, 1, 1).setNote("「all」と入れると全日の予定になる");
14

15
  console.log(`initializeSheet: 99999999999999999999999999999999999999999999999999999999999999999`);
16
  return true;
17
}

1
/**
2
 * @description Crop multi images to output each image by values in the specified area to output message.
3
 * @param {string} sheetName
4
 * @param {string[]{}} formParams
5
 * @return {string{}} key: "data", "statement"and "is_correct".
6
*/
7
function getObjAboutCorrectnessOFNamedRanges(sheetName, forms){
8
  const sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
9
  const namedRanges = sheet.getNamedRanges();
10
  let objRequredNamedRanges = {};
11
  let namedRange;
12
  let keyName = "";
13
  let rangeNames = forms.map(form => {
14
    return form["name"];
15
  });
16
  console.log(rangeNames);
17
  console.log(`getObjAboutCorrectnessOFNamedRanges: 11111111111111111111111111111111111111111111111111111`);
18
  rangeNames.forEach(name => {
19
    objRequredNamedRanges[name] = {};
20
  });
21
  let formObj = {}
22
  forms.forEach(f => {
23
    formObj[f["name"]] = {"rows": f["rows"], "columns": f["columns"]};
24
  });
25
  Object.keys(namedRanges).forEach(key => {
26
    namedRange = namedRanges[key];
27
    keyName = namedRange.getName();
28
    if(!(rangeNames.includes(keyName))){
29
      return;
30
    }
31
    objRequredNamedRanges[keyName]["row"] = namedRange.getRange().getRow();
32
    objRequredNamedRanges[keyName]["column"] = namedRange.getRange().getColumn();
33
    objRequredNamedRanges[keyName]["a1notation"] = namedRange.getRange().getA1Notation();
34
    objRequredNamedRanges[keyName]["rows"] = formObj[keyName]["rows"];
35
    objRequredNamedRanges[keyName]["columns"] = formObj[keyName]["columns"];
36
  });
37
  console.log(objRequredNamedRanges);
38
  console.log(`getObjAboutCorrectnessOFNamedRanges: 222222222222222222222222222222222222222222222222222222`);
39

40
  let texts = [];
41
  for (const [key, value] of Object.entries(objRequredNamedRanges)){
42
    texts.push(`'${key}': '${value["a1notation"]}'`);
43
  }
44
  console.log(texts);
45
  console.log(`getObjAboutCorrectnessOFNamedRanges: 333333333333333333333333333333333333333333333333333333`);
46

47
  let statement = getStatementLineBrokenToDisplayArrays(texts, `'${sheetName}' sheet must have NamedRanges.\nNow, target names are declared on the following ranges...`, ":\n\n", "\n");
48
  console.log(statement);
49
  console.log(`getObjAboutCorrectnessOFNamedRanges: 4444444444444444444444444444444444444444444444444444444`);
50

51
  let returnObj = {};
52
  returnObj["data"] = objRequredNamedRanges;
53
  returnObj["statement"] = statement;
54

55
  let ui = SpreadsheetApp.getUi();
56
  let reply = ui.alert(statement, ui.ButtonSet.YES_NO);
57
  if(reply === ui.Button.YES){
58
    returnObj["is_correct"] = true;
59
  }else if(reply === ui.Button.NO){
60
    console.log(`getObjAboutCorrectnessOFNamedRanges: 777777777777777777777777777777777777777777777777777777`);
61
    returnObj["is_correct"] = false;
62
  }else{
63
    console.log(`The user clicked the close button in the dialog's title bar.`);
64
    console.log(`getObjAboutCorrectnessOFNamedRanges: 888888888888888888888888888888888888888888888888888888`);
65
    returnObj["is_correct"] = false;
66
  }
67
  return returnObj;
68
}

1
{ startCellToInputMandatoryItems:
2
   [ [ 'mandatory_items', '', '', '', '', '' ],
3
     [ 'start_of_period',
4
       'end_of_period',
5
       'start_time',
6
       'end_time',
7
       'title',
8
       'color' ],
9
     [ '2024-05-06', '2024-05-24', '17:00:00', '18:00:00', 'スーパー玉出', 5 ] ],
10
  startCellToInputDayOfWeek:
11
   [ [ 'selected_days_of_week', '', '', '', '', '', '' ],
12
     [ 'sunday',
13
       'monday',
14
       'tuesday',
15
       'wednesday',
16
       'thursday',
17
       'friday',
18
       'saturday' ],
19
     [ false, true, false, false, false, true, false ] ],
20
  startCellToInputOptionalItems:
21
   [ [ 'optional_items', '', '', '', '', '' ],
22
     [ 'description',
23
       'location',
24
       'guests',
25
       'sendInvites',
26
       'to_be_decided_items_01',
27
       'to_be_decided_items_02' ],
28
     [ '', '', '', false, '', '' ] ],
29
  startCellToListColorIndices:
30
   [ [ 'color_indices', '', '', '', '', '', '', '', '', '', '' ],
31
     [ 'PALE_BLUE',
32
       'PALE_GREEN',
33
       'MAUVE',
34
       'PALE_RED',
35
       'YELLOW',
36
       'ORANGE',
37
       'CYAN',
38
       'GRAY',
39
       'BLUE',
40
       'GREEN',
41
       'RED' ],
42
     [ 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 ] ] }

1
{ is_mandatory_filled: true,
2
  is_color_index_correct: true,
3
  start_of_period: '2024-05-06',
4
  end_of_period: '2024-05-24',
5
  start_time: '17:00:00',
6
  end_time: '18:00:00',
7
  title: 'スーパー玉出',
8
  color: 5,
9
  selected_days_of_week: [ false, true, false, false, false, true, false ],
10
  description: '',
11
  location: '',
12
  guests: '',
13
  sendInvites: false,
14
  to_be_decided_items_01: '',
15
  to_be_decided_items_02: '' }

1
let statement = `<p>All mandatory items must be filled.</p>`; console.log(statement);
2
  if(!itemsObj["is_mandatory_filled"]){
3
    displayHtml("index_html", "Calendar input failed.", statement)
4
    return false;
5
  }
6
  statement = `<p>Select a correct color index.</p>`; console.log(statement);
7
  if(!itemsObj["is_color_index_correct"]){
8
    displayHtml("index_html", "Calendar input failed.", statement)
9
    return false;
10
  }
11
  statement = `<p>Guests must be specified with e-mail adress.</p>`; console.log(statement);
12
  if(!itemsObj["guests"] !== "" && !itemsObj["guests"].indexOf("@") === -1){
13
    displayHtml("index_html", "Calendar input failed.", statement)
14
    return false;
15
  }
16
  console.log(`inputCalendarWithSheet: 444444444444444444444444444444444444444444444444444444444444444444`);

1
/**
2
 * @description Input calendar.
3
 * @param {any{}} itemsObj
4
 * @param {boolean} isRecurring
5
 * @param {boolean} isRecording
6
 * @return {boolean}
7
*/
8
function inputCalendar(itemsObj, isRecurring=false, isRecording=true){
9
  const calendar = CalendarApp.getDefaultCalendar();
10
  const weekdaysOnGoogleCalendar = [
11
    CalendarApp.Weekday.SUNDAY
12
    , CalendarApp.Weekday.MONDAY
13
    , CalendarApp.Weekday.TUESDAY
14
    , CalendarApp.Weekday.WEDNESDAY
15
    , CalendarApp.Weekday.THURSDAY
16
    , CalendarApp.Weekday.FRIDAY
17
    , CalendarApp.Weekday.SATURDAY
18
  ];
19

20
  const valueReferingToAllDayAtCellOfStartOfPeriod = "all";
21
  const timeDiffGMT9 = 14;
22
  const timezoneStr = "";
23
  // const timezoneStr = "+09:00";
24

25
  let inputingWeekdays = () => {
26
    let wds = [];
27
    for(let i = 0; i < weekdaysOnGoogleCalendar.length; i++){
28
      itemsObj["selected_days_of_week"][i] ? wds.push(weekdaysOnGoogleCalendar[i]) : doNothing();
29
    }
30
    return wds;
31
  };
32
  console.log(inputingWeekdays());
33
  console.log(`inputCalendar: 111111111111111111111111111111111111111111111111111111111111111`);
34

35
  let title = itemsObj["title"];
36
  let recurrence;
37
  if(isRecurring){
38
    recurrence = CalendarApp.newRecurrence().addWeeklyRule()
39
      .onlyOnWeekdays(inputingWeekdays())
40
      .until(new Date(`${itemsObj["end_of_period"]}T23:59:59${timezoneStr}`));
41
  }
42
  let options = {};
43
  ["description", "location", "guests", "sendInvites"].forEach(option => {
44
    itemsObj[option] !== "" ? options[option] = itemsObj[option] : doNothing();
45
  })
46
  console.log(options);
47
  console.log(`inputCalendar: 2222222222222222222222222222222222222222222222222222222222222222222`);
48

49
  let eventSeries;
50
  let startTime, endTime;
51
  if(itemsObj["start_time"] === valueReferingToAllDayAtCellOfStartOfPeriod){
52
    startTime = new Date(`${itemsObj["start_of_period"]}T00:00:00${timezoneStr}`);
53
    if(isRecurring){
54
      if(Object.keys(options).length === 0){
55
        eventSeries = calendar.createAllDayEventSeries(title, startTime, recurrence);
56
      }else{
57
        eventSeries = calendar.createAllDayEventSeries(title, startTime, recurrence, options);
58
      }
59
    }else{
60
      endTime = new Date(`${itemsObj["end_of_period"]}T00:00:00${timezoneStr}`);
61
      let inputtingTimestampsFromStart = getInputtingTimestamps(itemsObj["selected_days_of_week"], startTime, endTime);
62
      if(Object.keys(options).length === 0){
63
        inputtingTimestampsFromStart.forEach(ts => {
64
          let inputDate = new Date();
65
          inputDate.setTime(ts);
66
          console.log(inputDate);
67
          console.log(`inputCalendar: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`);
68
          eventSeries = calendar.createAllDayEvent(title, inputDate);
69
          eventSeries.setColor(itemsObj["color"]);
70
        })
71
      }else{
72
        inputtingTimestampsFromStart.forEach(ts => {
73
          let inputDate = new Date();
74
          inputDate.setTime(ts);
75
          console.log(inputDate);
76
          console.log(`inputCalendar: {{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}`);
77
          eventSeries = calendar.createAllDayEvent(title, inputDate, options);
78
          eventSeries.setColor(itemsObj["color"]);
79
        })
80
      }
81
    }
82
    console.log(`inputCalendar: 4444444444444444444444444444444444444444444444444444444444444444444`);
83

84
  }else{
85
    startTime = new Date(`${itemsObj["start_of_period"]}T${itemsObj["start_time"]}`);
86
    let tempTimestamp = startTime.getTime() - timeDiffGMT9 * 60 * 60 * 1000;
87
    startTime.setTime(tempTimestamp);
88
    endTime = new Date(`${itemsObj["start_of_period"]}T${itemsObj["end_time"]}`);
89
    tempTimestamp = endTime.getTime() - timeDiffGMT9 * 60 * 60 * 1000;
90
    endTime.setTime(tempTimestamp);
91
    console.log(startTime);
92
    console.log(endTime);
93
    console.log(`inputCalendar: 55555555555555555555555555555555555555555555555555555555555555555555`);
94

95
    let endTime02 = new Date(`${itemsObj["end_of_period"]}T00:00:00${timezoneStr}`);
96
    if(isRecurring){
97
      if(Object.keys(options).length === 0){
98
        eventSeries = calendar.createEventSeries(title, startTime, endTime, recurrence);
99
      }else{
100
        eventSeries = calendar.createEventSeries(title, startTime, endTime, recurrence, options);
101
      }
102
      console.log(`inputCalendar: 6666666666666666666666666666666666666666666666666666666666666666666`);
103
    }else{
104
      let inputtingTimestampsFromStart01 = getInputtingTimestamps(itemsObj["selected_days_of_week"], startTime, endTime02, itemsObj["start_time"]);
105
      let inputtingTimestampsFromStart02 = getInputtingTimestamps(itemsObj["selected_days_of_week"], startTime, endTime02, itemsObj["end_time"]);
106
      if(Object.keys(options).length === 0){
107
        for(let i = 0; i < inputtingTimestampsFromStart01.length; i++){
108
          let inputDate01 = new Date();
109
          inputDate01.setTime(inputtingTimestampsFromStart01[i] - timeDiffGMT9 * 60 * 60 * 1000);
110
          let inputDate02 = new Date();
111
          inputDate02.setTime(inputtingTimestampsFromStart02[i] - timeDiffGMT9 * 60 * 60 * 1000);
112
          console.log(inputDate01);
113
          console.log(inputDate02);
114
          console.log(`inputCalendar: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^`);
115
          eventSeries = calendar.createEvent(title, inputDate01, inputDate02);
116
          eventSeries.setColor(itemsObj["color"]);
117
        }
118
      }else{
119
        for(let i = 0; i < inputtingTimestampsFromStart01.length; i++){
120
          let inputDate01 = new Date();
121
          inputDate01.setTime(inputtingTimestampsFromStart01[i] - timeDiffGMT9 * 60 * 60 * 1000);
122
          let inputDate02 = new Date();
123
          inputDate02.setTime(inputtingTimestampsFromStart02[i] - timeDiffGMT9 * 60 * 60 * 1000);
124
          console.log(inputDate01);
125
          console.log(inputDate02);
126
          console.log(`inputCalendar: >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>`);
127
          eventSeries = calendar.createEvent(title, inputDate01, inputDate02, options);
128
          eventSeries.setColor(itemsObj["color"]);
129
        }
130
      }
131
    }
132
  }
133
  eventSeries.setColor(itemsObj["color"]);
134
  console.log(options);
135
  console.log(`inputCalendar: 777777777777777777777777777777777777777777777777777777777777777777`);
136

137
  console.log(`inputCalendar: 8888888888888888888888888888888888888888888888888888888888888888`);
138

139
  console.log(`inputCalendar: 99999999999999999999999999999999999999999999999999999999999999999`);
140
}

1
  if(itemsObj["start_time"] === valueReferingToAllDayAtCellOfStartOfPeriod){
2
    startTime = new Date(`${itemsObj["start_of_period"]}T00:00:00${timezoneStr}`);
3
    if(isRecurring){
4
      if(Object.keys(options).length === 0){
5
        eventSeries = calendar.createAllDayEventSeries(title, startTime, recurrence);
6
      }else{
7
        eventSeries = calendar.createAllDayEventSeries(title, startTime, recurrence, options);
8
      }
9
    }else{
10
      endTime = new Date(`${itemsObj["end_of_period"]}T00:00:00${timezoneStr}`);
11
      let inputtingTimestampsFromStart = getInputtingTimestamps(itemsObj["selected_days_of_week"], startTime, endTime);
12
      if(Object.keys(options).length === 0){
13
        inputtingTimestampsFromStart.forEach(ts => {
14
          let inputDate = new Date();
15
          inputDate.setTime(ts);
16
          console.log(inputDate);
17
          console.log(`inputCalendar: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`);
18
          eventSeries = calendar.createAllDayEvent(title, inputDate);
19
          eventSeries.setColor(itemsObj["color"]);
20
        })
21
      }else{
22
        inputtingTimestampsFromStart.forEach(ts => {
23
          let inputDate = new Date();
24
          inputDate.setTime(ts);
25
          console.log(inputDate);
26
          console.log(`inputCalendar: {{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}`);
27
          eventSeries = calendar.createAllDayEvent(title, inputDate, options);
28
          eventSeries.setColor(itemsObj["color"]);
29
        })
30
      }
31
    }
32
    console.log(`inputCalendar: 4444444444444444444444444444444444444444444444444444444444444444444`);
33

34
  }else{

1
      let inputtingTimestampsFromStart01 = getInputtingTimestamps(itemsObj["selected_days_of_week"], startTime, endTime02, itemsObj["start_time"]);
2
      let inputtingTimestampsFromStart02 = getInputtingTimestamps(itemsObj["selected_days_of_week"], startTime, endTime02, itemsObj["end_time"]);
3
      if(Object.keys(options).length === 0){
4
        for(let i = 0; i < inputtingTimestampsFromStart01.length; i++){
5
          let inputDate01 = new Date();
6
          inputDate01.setTime(inputtingTimestampsFromStart01[i] - timeDiffGMT9 * 60 * 60 * 1000);
7
          let inputDate02 = new Date();
8
          inputDate02.setTime(inputtingTimestampsFromStart02[i] - timeDiffGMT9 * 60 * 60 * 1000);
9
          console.log(inputDate01);
10
          console.log(inputDate02);
11
          console.log(`inputCalendar: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^`);
12
          eventSeries = calendar.createEvent(title, inputDate01, inputDate02);
13
          eventSeries.setColor(itemsObj["color"]);
14
        }
15
      }else{
16
        for(let i = 0; i < inputtingTimestampsFromStart01.length; i++){
17
          let inputDate01 = new Date();
18
          inputDate01.setTime(inputtingTimestampsFromStart01[i] - timeDiffGMT9 * 60 * 60 * 1000);
19
          let inputDate02 = new Date();
20
          inputDate02.setTime(inputtingTimestampsFromStart02[i] - timeDiffGMT9 * 60 * 60 * 1000);
21
          console.log(inputDate01);
22
          console.log(inputDate02);
23
          console.log(`inputCalendar: >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>`);
24
          eventSeries = calendar.createEvent(title, inputDate01, inputDate02, options);
25
          eventSeries.setColor(itemsObj["color"]);
26
        }
27
      }

1
/**
2
 * @description Get timestamps to input event  to calendar.
3
 * @param {boolean[]} selectedDaysOfWeek: length must be 7.
4
 * @param {Date()} startDate
5
 * @param {Date()} endDate
6
 * @param {string} addingTime
7
 * @return {number[]}
8
*/
9
function getInputtingTimestamps(selectedDaysOfWeek, startDate, endDate, addingTime="00:00:00"){
10
  const weekdaysOnPrimitiveJsString = [
11
    "Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"
12
  ];
13
  const timezoneStr = "";
14
  // const timezoneStr = "+09:00";
15
  let dow = startDate[Symbol.toPrimitive]("string").substring(0, 3); // get day of week
16
  let dowIndex = weekdaysOnPrimitiveJsString.indexOf(dow);
17
  let tempTimestamp01 = startDate.getTime();
18
  let tempTimestamp02 = endDate.getTime();
19
  let oneDayInTimestamp = 24 * 60 * 60 * 1000;
20
  let periodDays = Math.floor((tempTimestamp02 - tempTimestamp01) / oneDayInTimestamp) + 2; // なぜかタイムゾーンがズレるので仕方なく+2してる。本来は+1の筈。
21
  let inputtingTimestampsFromStart = []; //
22
  let s;
23
  console.log(startDate);
24
  console.log(endDate);
25
  console.log(dow);
26
  console.log(dowIndex);
27
  console.log(`getInputtingTimestamps: 3333333333333333333333333333333333333333333333333333333333333333333`);
28
  console.log(tempTimestamp01);
29
  console.log(tempTimestamp02);
30
  console.log(periodDays);
31
  console.log(`getInputtingTimestamps: 4444444444444444444444444444444444444444444444444444444444444444444`);
32
  console.log(tempTimestamp01);
33
  console.log(oneDayInTimestamp);
34
  console.log(`getInputtingTimestamps: 5555555555555555555555555555555555555555555555555555555555555555555`);
35
  for(let i = 0; i < periodDays; i++){
36
    s = (dowIndex + i) % (weekdaysOnPrimitiveJsString.length);
37
    console.log(s);
38
    console.log(selectedDaysOfWeek[s]);
39
    let at = new Date(`2001-04-01T${addingTime}${timezoneStr}`);
40
    let atTimestamp = (at.getHours() * 60 + at.getMinutes()) * 60 * 1000;
41
    console.log(addingTime);
42
    console.log(atTimestamp);
43
    console.log(`getInputtingTimestamps: 66666666666666666666666666666666666666666666666666666666666666666666`);
44
    selectedDaysOfWeek[s] ? inputtingTimestampsFromStart.push(tempTimestamp01 + i * oneDayInTimestamp + atTimestamp) : doNothing();
45
    // selectedDaysOfWeek[s] ? inputtingTimestampsFromStart.push(tempTimestamp01 + i * oneDayInTimestamp) : doNothing();
46
  }
47
  console.log(inputtingTimestampsFromStart);
48
  console.log(`getInputtingTimestamps: &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&`);
49

50
  return inputtingTimestampsFromStart;
51
}

1
  let eventSeries;
2
  let startTime, endTime;
3
  if(itemsObj["start_time"] === valueReferingToAllDayAtCellOfStartOfPeriod){
4
    startTime = new Date(`${itemsObj["start_of_period"]}T00:00:00${timezoneStr}`);
5
    if(isRecurring){ // 繰り返す
6
      if(Object.keys(options).length === 0){
7
        eventSeries = calendar.createAllDayEventSeries(title, startTime, recurrence);
8
      }else{
9
        eventSeries = calendar.createAllDayEventSeries(title, startTime, recurrence, options);
10
      }
11
    }else{ // 繰り返さない
12
      endTime = new Date(`${itemsObj["end_of_period"]}T00:00:00${timezoneStr}`);
13
      let inputtingTimestampsFromStart = getInputtingTimestamps(itemsObj["selected_days_of_week"], startTime, endTime);
14
      if(Object.keys(options).length === 0){
15
        inputtingTimestampsFromStart.forEach(ts => {
16
          let inputDate = new Date();
17
          inputDate.setTime(ts);
18
          console.log(inputDate);
19
          console.log(`inputCalendar: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`);
20
          eventSeries = calendar.createAllDayEvent(title, inputDate);
21
          eventSeries.setColor(itemsObj["color"]);
22
        })
23
      }else{
24
        inputtingTimestampsFromStart.forEach(ts => {
25
          let inputDate = new Date();
26
          inputDate.setTime(ts);
27
          console.log(inputDate);
28
          console.log(`inputCalendar: {{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}`);
29
          eventSeries = calendar.createAllDayEvent(title, inputDate, options);
30
          eventSeries.setColor(itemsObj["color"]);
31
        })
32
      }
33
    }
34
    console.log(`inputCalendar: 4444444444444444444444444444444444444444444444444444444444444444444`);
35

36
  }else{