回答編集履歴
4
修正
test
CHANGED
|
File without changes
|
3
ついき
test
CHANGED
|
@@ -10,13 +10,19 @@
|
|
|
10
10
|
|
|
11
11
|
const sheet3 = "シート3";
|
|
12
12
|
|
|
13
|
+
Logger.log("this sheet is "+ sheet.getName());
|
|
14
|
+
|
|
13
15
|
if(sheet.getName() !== sheet3) { return; }
|
|
14
16
|
|
|
15
17
|
const done = "done";
|
|
16
18
|
|
|
19
|
+
Logger.log("value is " + e.value);
|
|
20
|
+
|
|
17
21
|
if(e.value !== done) { return; }
|
|
18
22
|
|
|
19
23
|
const colH = 8;
|
|
24
|
+
|
|
25
|
+
Logger.log("editing colum at "+e.range.getColumn());
|
|
20
26
|
|
|
21
27
|
if(e.range.getColumn() !== colH) { return; }
|
|
22
28
|
|
2
修正
test
CHANGED
|
@@ -20,7 +20,7 @@
|
|
|
20
20
|
|
|
21
21
|
if(e.range.getColumn() !== colH) { return; }
|
|
22
22
|
|
|
23
|
-
const taskid = e.range.off
|
|
23
|
+
const taskid = e.range.offset(0, -7).getValue(); //offsetの指定は自信ない
|
|
24
24
|
|
|
25
25
|
const token = "とーくん";
|
|
26
26
|
|
1
修正
test
CHANGED
|
@@ -3,6 +3,8 @@
|
|
|
3
3
|
```javascript
|
|
4
4
|
|
|
5
5
|
function q176577(e) {
|
|
6
|
+
|
|
7
|
+
if(e === undefined) { e = buildEventObjByActiveCell(); }
|
|
6
8
|
|
|
7
9
|
const sheet = e.range.getSheet();
|
|
8
10
|
|
|
@@ -46,4 +48,20 @@
|
|
|
46
48
|
|
|
47
49
|
}
|
|
48
50
|
|
|
51
|
+
function buildEventObjByActiveCell() {
|
|
52
|
+
|
|
53
|
+
const sheet = SpreadsheetApp.getActiveSheet();
|
|
54
|
+
|
|
55
|
+
const cell = sheet.getActiveCell();
|
|
56
|
+
|
|
57
|
+
var e = {};
|
|
58
|
+
|
|
59
|
+
e.value = cell.getValue();
|
|
60
|
+
|
|
61
|
+
e.range = cell;
|
|
62
|
+
|
|
63
|
+
return e;
|
|
64
|
+
|
|
65
|
+
}
|
|
66
|
+
|
|
49
67
|
```
|