回答編集履歴
3
b
answer
CHANGED
|
@@ -13,7 +13,7 @@
|
|
|
13
13
|
var myCal=CalendarApp.getCalendarById(''); //特定IDのカレンダーを取得
|
|
14
14
|
var schedules = myCal.getEventsForDay(new Date()); //予定オブジェクトの生成
|
|
15
15
|
|
|
16
|
-
var cur = (num_row == 0) ? (new Date()).getFullYear() + "-1" : mySheet.getRange(num_row, 1).getValue();
|
|
16
|
+
var cur = (num_row == 0) ? (new Date()).getFullYear() + "" + ((new Date()).getMonth() + 1) + "-1" : mySheet.getRange(num_row, 1).getValue();
|
|
17
17
|
// 予定を繰り返し出力する
|
|
18
18
|
for(var index = 0; index < schedules.length; index++) {
|
|
19
19
|
var no = getNext(cur);
|
2
a
answer
CHANGED
|
@@ -10,7 +10,7 @@
|
|
|
10
10
|
|
|
11
11
|
var no=1; //No
|
|
12
12
|
|
|
13
|
-
var myCal=CalendarApp.getCalendarById('
|
|
13
|
+
var myCal=CalendarApp.getCalendarById(''); //特定IDのカレンダーを取得
|
|
14
14
|
var schedules = myCal.getEventsForDay(new Date()); //予定オブジェクトの生成
|
|
15
15
|
|
|
16
16
|
var cur = (num_row == 0) ? (new Date()).getFullYear() + "-1" : mySheet.getRange(num_row, 1).getValue();
|
1
a
answer
CHANGED
|
@@ -7,10 +7,10 @@
|
|
|
7
7
|
var mySheet=SpreadsheetApp.getActiveSheet(); //シートを取得
|
|
8
8
|
var num_row = mySheet.getDataRange().getLastRow(); //新規行番号を取得
|
|
9
9
|
var FORMAT_TIME = 'mm/dd'; // 時間表記
|
|
10
|
-
|
|
10
|
+
|
|
11
11
|
var no=1; //No
|
|
12
|
-
|
|
12
|
+
|
|
13
|
-
var myCal=CalendarApp.getCalendarById('
|
|
13
|
+
var myCal=CalendarApp.getCalendarById('****'); //特定IDのカレンダーを取得
|
|
14
14
|
var schedules = myCal.getEventsForDay(new Date()); //予定オブジェクトの生成
|
|
15
15
|
|
|
16
16
|
var cur = (num_row == 0) ? (new Date()).getFullYear() + "-1" : mySheet.getRange(num_row, 1).getValue();
|
|
@@ -19,13 +19,13 @@
|
|
|
19
19
|
var no = getNext(cur);
|
|
20
20
|
mySheet.appendRow([no, myCal.getName(), schedules[index].getTitle(), schedules[index].getStartTime(),schedules[index].getDescription(), schedules[index].getLocation()]);
|
|
21
21
|
cur = no;
|
|
22
|
-
mySheet.getRange(++
|
|
22
|
+
mySheet.getRange(++num_row, 4).setNumberFormat(FORMAT_TIME);
|
|
23
23
|
}
|
|
24
|
-
|
|
24
|
+
|
|
25
25
|
}
|
|
26
26
|
function getNext(current) {
|
|
27
|
-
var splitted =
|
|
27
|
+
var splitted = current.split('-');
|
|
28
|
-
var next = splitted[1] + 1;
|
|
28
|
+
var next = Number(splitted[1]) + 1;
|
|
29
29
|
return splitted[0] + "-" + next;
|
|
30
30
|
}
|
|
31
31
|
```
|