質問編集履歴
4
Java とjavascripを明確に分けた
title
CHANGED
|
@@ -1,1 +1,1 @@
|
|
|
1
|
-
GAS
|
|
1
|
+
GAS 問い合わせ件数、行数が異なるメールをスプレットシートへ転記したい。
|
body
CHANGED
|
File without changes
|
3
Java とjavascripを明確に分けた
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -72,22 +72,8 @@
|
|
|
72
72
|
|
|
73
73
|
let tel = plainBody.match(/ＴＥＬ：(.*)/);
|
|
74
74
|
|
|
75
|
-
let
|
|
75
|
+
let name = plainBody.match(/商 品 名：(.*)/);
|
|
76
76
|
|
|
77
|
-
let buildType = plainBody.match(/B：(.*)/);
|
|
78
|
-
|
|
79
|
-
let buildLocation = plainBody.match(/C：(.*)/);
|
|
80
|
-
|
|
81
|
-
let buildNearestStation = plainBody.match(/D：(.*)/);
|
|
82
|
-
|
|
83
|
-
let buildDistance = plainBody.match(/E：(.*)/);
|
|
84
|
-
|
|
85
|
-
let buildRentFee = plainBody.match(/F：(.*)/);
|
|
86
|
-
|
|
87
|
-
let buildFloorPlan = plainBody.match(/G：(.*)/);
|
|
88
|
-
|
|
89
|
-
let buildOccupiedArea = plainBody.match(/H：(.*)/);
|
|
90
|
-
|
|
91
77
|
let sheet = SpreadsheetApp.getActive().getSheetByName('aaaa')
|
|
92
78
|
|
|
93
79
|
let lastRow = sheet.getLastRow() + 1;
|
|
@@ -96,14 +82,7 @@
|
|
|
96
82
|
sheet.getRange(lastRow, 2).setValue(name[1]);
|
|
97
83
|
sheet.getRange(lastRow, 3).setValue(email[1]);
|
|
98
84
|
sheet.getRange(lastRow, 4).setValue(tel[1]);
|
|
99
|
-
sheet.getRange(lastRow, 5).setValue(
|
|
85
|
+
sheet.getRange(lastRow, 5).setValue(name[1]);
|
|
100
|
-
sheet.getRange(lastRow, 6).setValue(buildType[1]);
|
|
101
|
-
sheet.getRange(lastRow, 7).setValue(buildLocation[1]);
|
|
102
|
-
sheet.getRange(lastRow, 8).setValue(buildNearestStation[1]);
|
|
103
|
-
sheet.getRange(lastRow, 9).setValue(buildDistance[1]);
|
|
104
|
-
sheet.getRange(lastRow, 10).setValue(buildRentFee[1]);
|
|
105
|
-
sheet.getRange(lastRow, 11).setValue(buildFloorPlan[1]);
|
|
106
|
-
sheet.getRange(lastRow, 12).setValue(buildOccupiedArea[1]);
|
|
107
86
|
});
|
|
108
87
|
|
|
109
88
|
let label = GmailApp.getUserLabelByName('処理済み');
|
2
title
CHANGED
|
File without changes
|
body
CHANGED
|
File without changes
|
1
title
CHANGED
|
@@ -1,1 +1,1 @@
|
|
|
1
|
-
GAS/
|
|
1
|
+
GAS/JavaScript 問い合わせ件数、行数が異なるメールをスプレットシートへ転記したい。
|
body
CHANGED
|
File without changes
|