質問編集履歴
4
修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -18,7 +18,7 @@
|
|
18
18
|
【コード】
|
19
19
|
```ここに言語を入力
|
20
20
|
var MAIL_ADDRESS3 = ["XXX"];
|
21
|
-
function SUMMARY_Trend()
|
21
|
+
function SUMMARY_Trend() {
|
22
22
|
var ss = SpreadsheetApp.openById(SpreadsheetApp.getActiveSpreadsheet().getId());
|
23
23
|
var sheet = ss.getSheetByName("XXX"); // シートの名前
|
24
24
|
|
3
sy修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -58,7 +58,7 @@
|
|
58
58
|
if (sheet.getRange("A2").getValue() === '#N/A') {
|
59
59
|
return false;
|
60
60
|
} else {
|
61
|
-
GmailApp.sendEmail(MAIL_ADDRESS3, "
|
61
|
+
GmailApp.sendEmail(MAIL_ADDRESS3, "test", "body", {htmlBody : tableList.join("\n")});
|
62
62
|
}
|
63
63
|
|
64
64
|
/**
|
2
修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -33,7 +33,7 @@
|
|
33
33
|
}
|
34
34
|
var style = " style='border:1px #000000 solid;border-collapse:collapse;'";
|
35
35
|
var tableList = [];
|
36
|
-
tableList.push("<p>
|
36
|
+
tableList.push("<p> test</p>");
|
37
37
|
|
38
38
|
//データを取得し、HTMLのテーブルを作成。
|
39
39
|
tableList.push("<table" + style + ">");
|
1
修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -17,13 +17,13 @@
|
|
17
17
|
![イメージ説明](https://ddjkaamml8q8x.cloudfront.net/questions/2022-05-16/3fd793e6-ef6b-4ba0-89b8-9a101201805b.png)
|
18
18
|
【コード】
|
19
19
|
```ここに言語を入力
|
20
|
-
var MAIL_ADDRESS3 = ["XXX];
|
20
|
+
var MAIL_ADDRESS3 = ["XXX"];
|
21
|
-
function SUMMARY()
|
21
|
+
function SUMMARY_Trend()
|
22
22
|
var ss = SpreadsheetApp.openById(SpreadsheetApp.getActiveSpreadsheet().getId());
|
23
23
|
var sheet = ss.getSheetByName("XXX"); // シートの名前
|
24
24
|
|
25
|
-
//
|
25
|
+
// 進捗が100%以外のタスクのIndexを取得
|
26
|
-
var index = getHeadIndex(sheet,
|
26
|
+
var index = getHeadIndex(sheet, "Less than a Week");
|
27
27
|
var range = sheet.getRange("a1");
|
28
28
|
var items = [];
|
29
29
|
for(i=0;i<sheet.getLastRow();i++) {
|
@@ -33,7 +33,7 @@
|
|
33
33
|
}
|
34
34
|
var style = " style='border:1px #000000 solid;border-collapse:collapse;'";
|
35
35
|
var tableList = [];
|
36
|
-
tableList.push("<p>
|
36
|
+
tableList.push("<p> JAPAN TakeOver Holding , List of Possible GCN cleints, The deadline will be less than a week from Today \n LINK:https://docs.google.com/spreadsheets/d/1YsoOuH_hZiH_QOlsMdfbaZtAY9EHTCQjonr9BUPkk9c/edit#gid=1163163182 </p>");
|
37
37
|
|
38
38
|
//データを取得し、HTMLのテーブルを作成。
|
39
39
|
tableList.push("<table" + style + ">");
|
@@ -54,7 +54,10 @@
|
|
54
54
|
tableList.push("<tr" + style + "><td" + style + ">" + study.join("</td><td" + style + ">") + "</td></tr>");
|
55
55
|
}
|
56
56
|
tableList.push("</table>");
|
57
|
-
|
57
|
+
//If分でNAの場合メールを送らない
|
58
|
+
if (sheet.getRange("A2").getValue() === '#N/A') {
|
59
|
+
return false;
|
60
|
+
} else {
|
58
61
|
GmailApp.sendEmail(MAIL_ADDRESS3, "Takeover Deadline (Auto_Email)", "body", {htmlBody : tableList.join("\n")});
|
59
62
|
}
|
60
63
|
|