回答編集履歴
1
修正
test
CHANGED
@@ -1,16 +1,10 @@
|
|
1
|
-
|
1
|
+
未検証。
|
2
2
|
|
3
|
-
|
4
|
-
|
5
|
-
* 定時実行
|
6
|
-
|
7
|
-
|
3
|
+
がんばってバグ取りしてください
|
8
4
|
|
9
5
|
```javascript
|
10
6
|
|
11
|
-
function q176354() {
|
7
|
+
function q176354(e) {
|
12
|
-
|
13
|
-
const book = SpreadsheetApp.openById('1nF4EKGDdmGbn3g1fVX4hpjSpjzff0XMFZlDah6i8pDU').getSheetByName("");
|
14
8
|
|
15
9
|
const srcSheetName = "コピー元シート名";
|
16
10
|
|
@@ -18,15 +12,19 @@
|
|
18
12
|
|
19
13
|
const allowance = "●●";
|
20
14
|
|
21
|
-
const
|
15
|
+
const sh = e.range.getSheet();
|
22
16
|
|
23
|
-
|
17
|
+
if(sh.getName() !== srcSheetName) return;
|
24
18
|
|
25
|
-
if(
|
19
|
+
if(e.range.getColumn() !== 10) return;
|
26
20
|
|
27
|
-
|
21
|
+
if(e.value !== allowance) return;
|
28
22
|
|
23
|
+
const lastCol = sh.getLastColumn();
|
24
|
+
|
29
|
-
|
25
|
+
const val = e.range.getSheet().getRange(e.range.getRow(), 1, 1, lastCol).getValues();
|
26
|
+
|
27
|
+
e.source.getSheetByName(dstSheetName).appendRow(val[0]);
|
30
28
|
|
31
29
|
}
|
32
30
|
|