回答編集履歴
1
test
CHANGED
@@ -6,11 +6,11 @@
|
|
6
6
|
|
7
7
|
let employeeValues = employeeSheet.getRange(4, 1, employeeSheet.getLastRow() , 3).getValues();
|
8
8
|
|
9
|
-
|
9
|
+
//employeeNameにA社の社員氏名を入れたい
|
10
|
-
|
10
|
+
let employeeName = [];
|
11
|
-
|
11
|
+
employeeValues.forEach(value => {
|
12
|
-
|
12
|
+
if(value[2] == 'A社'){
|
13
|
-
|
13
|
+
employeeName.push(value[0]);
|
14
|
-
|
14
|
+
}
|
15
|
-
|
15
|
+
});
|
16
16
|
```
|