質問編集履歴
1
訂正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -32,20 +32,23 @@
|
|
|
32
32
|
var codevalue = datas1[i][5];
|
|
33
33
|
var emailvalue = datas1[i][17];
|
|
34
34
|
object[codevalue] = emailvalue;
|
|
35
|
+
|
|
35
36
|
}
|
|
36
37
|
//真顧客マスタ取得
|
|
37
38
|
for(var p=2; p<=datas.length; p++){
|
|
38
39
|
var emailplace = sheet.getRange(p,10);
|
|
39
40
|
var code = sheet.getRange(p,1).getValue();
|
|
40
|
-
|
|
41
41
|
|
|
42
|
+
|
|
43
|
+
|
|
42
44
|
if(emailplace.isBlank()){
|
|
43
|
-
emailplace.setValue(object[
|
|
45
|
+
emailplace.setValue(object[code]);
|
|
44
|
-
|
|
45
46
|
}//if done
|
|
46
|
-
|
|
47
|
+
}//for done
|
|
48
|
+
|
|
47
49
|
}
|
|
48
50
|
|
|
51
|
+
|
|
49
52
|
```
|
|
50
53
|
|
|
51
54
|
### 試したこと
|