回答編集履歴
1
コード
test
CHANGED
|
@@ -12,12 +12,12 @@
|
|
|
12
12
|
let year = today.getFullYear();
|
|
13
13
|
|
|
14
14
|
let monthEng = plainBody.match(/Deadline: ([A-Za-z]{3,9}) /)[1];
|
|
15
|
-
let monthNum = new Date(Date.parse(monthEng +"
|
|
15
|
+
let monthNum = new Date(Date.parse(monthEng +" 1, "+year)).getMonth() + 1;
|
|
16
16
|
|
|
17
|
-
let sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(""
|
|
17
|
+
let sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("シート名");
|
|
18
18
|
let lastRow = sheet.getLastRow();
|
|
19
19
|
let range = sheet.getRange(lastRow+1,1,1,4);
|
|
20
|
-
range.setValues([[year, monthNum, ""
|
|
20
|
+
range.setValues([[year, monthNum, "", ""]]);
|
|
21
21
|
});
|
|
22
22
|
}
|
|
23
23
|
```
|