回答編集履歴
2
誤字の修正
test
CHANGED
|
@@ -6,27 +6,31 @@
|
|
|
6
6
|
|
|
7
7
|
```ここに言語を入力
|
|
8
8
|
|
|
9
|
-
function
|
|
9
|
+
function set_last_update() {
|
|
10
10
|
|
|
11
11
|
|
|
12
12
|
|
|
13
|
-
|
|
13
|
+
var sh=SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
|
|
14
14
|
|
|
15
|
-
|
|
15
|
+
if (sh.getSheetName() == "日程") {
|
|
16
16
|
|
|
17
17
|
|
|
18
18
|
|
|
19
|
-
|
|
19
|
+
var activerange=sh.getActiveRange();
|
|
20
20
|
|
|
21
|
-
var editRow = e.range.rowStart
|
|
22
21
|
|
|
23
|
-
sheet.getRange(editRow,2).setValue(new Date())
|
|
24
22
|
|
|
25
|
-
|
|
23
|
+
var activerow=activerange.getRow();
|
|
26
24
|
|
|
27
|
-
|
|
28
25
|
|
|
26
|
+
|
|
27
|
+
sh.getRange(activerow, 2).setValue(new Date());
|
|
28
|
+
|
|
29
|
+
|
|
30
|
+
|
|
31
|
+
}else{
|
|
32
|
+
|
|
29
|
-
|
|
33
|
+
}
|
|
30
34
|
|
|
31
35
|
}
|
|
32
36
|
|
1
誤字の修正
test
CHANGED
|
@@ -12,7 +12,7 @@
|
|
|
12
12
|
|
|
13
13
|
var sheet = SpreadsheetApp.getActiveSheet()
|
|
14
14
|
|
|
15
|
-
if (sheet.getSheetName() == "
|
|
15
|
+
if (sheet.getSheetName() == "日程") {
|
|
16
16
|
|
|
17
17
|
|
|
18
18
|
|