回答編集履歴
5
修正
answer
CHANGED
|
@@ -8,19 +8,20 @@
|
|
|
8
8
|
var column = sheet.getLastColumn(); //列数
|
|
9
9
|
var range = sheet.getDataRange(); //sheetから範囲指定するための準備
|
|
10
10
|
var message = "";
|
|
11
|
+
|
|
11
12
|
for (var i = 1; i <= column; i++) {
|
|
12
13
|
var item = range.getCell(1, i).getValue(); //1行目
|
|
13
|
-
var value =
|
|
14
|
+
var value = range.getCell(row, i).getValue(); //最終行
|
|
15
|
+
if (item == "タイムスタンプ" || item == "出勤日" || item == "退勤日"){
|
|
14
|
-
|
|
16
|
+
var date = new Date(value)
|
|
15
|
-
|
|
17
|
+
var weeks = ["日","月","火","水","木","金","土"];
|
|
16
|
-
|
|
18
|
+
var weekstr = weeks[date.getDay()];
|
|
17
|
-
|
|
19
|
+
var ymd = Utilities.formatDate(date, "Asia/Tokyo", "yyyy/MM/dd");
|
|
18
|
-
|
|
19
|
-
if (item == "タイムスタンプ"){
|
|
20
|
-
var hms = Utilities.formatDate(value, "Asia/Tokyo", "HH:mm:ss");
|
|
21
|
-
value = ymd + "(" + weekstr + ") " + hms;
|
|
22
|
-
}else if (item == "出勤日" || item == "退勤日") {
|
|
23
20
|
value = ymd + "(" + weekstr + ")"
|
|
21
|
+
if (item == "タイムスタンプ"){
|
|
22
|
+
var hms = Utilities.formatDate(date, "Asia/Tokyo", "HH:mm:ss");
|
|
23
|
+
value += " " + hms;
|
|
24
|
+
}
|
|
24
25
|
}
|
|
25
26
|
message += "\n■" + item + "\n" + value;
|
|
26
27
|
}
|
4
修正
answer
CHANGED
|
@@ -11,6 +11,7 @@
|
|
|
11
11
|
for (var i = 1; i <= column; i++) {
|
|
12
12
|
var item = range.getCell(1, i).getValue(); //1行目
|
|
13
13
|
var value = new Date(range.getCell(row, i).getValue()); //最終行
|
|
14
|
+
if (value == null) continue;
|
|
14
15
|
var weeks = ["日","月","火","水","木","金","土"];
|
|
15
16
|
var weekstr = weeks[value.getDay()];
|
|
16
17
|
var ymd = Utilities.formatDate(value, "Asia/Tokyo", "yyyy/MM/dd");
|
3
修正
answer
CHANGED
|
@@ -10,7 +10,7 @@
|
|
|
10
10
|
var message = "";
|
|
11
11
|
for (var i = 1; i <= column; i++) {
|
|
12
12
|
var item = range.getCell(1, i).getValue(); //1行目
|
|
13
|
-
var value = range.getCell(row, i).getValue(); //最終行
|
|
13
|
+
var value = new Date(range.getCell(row, i).getValue()); //最終行
|
|
14
14
|
var weeks = ["日","月","火","水","木","金","土"];
|
|
15
15
|
var weekstr = weeks[value.getDay()];
|
|
16
16
|
var ymd = Utilities.formatDate(value, "Asia/Tokyo", "yyyy/MM/dd");
|
2
修正
answer
CHANGED
|
@@ -19,7 +19,7 @@
|
|
|
19
19
|
var hms = Utilities.formatDate(value, "Asia/Tokyo", "HH:mm:ss");
|
|
20
20
|
value = ymd + "(" + weekstr + ") " + hms;
|
|
21
21
|
}else if (item == "出勤日" || item == "退勤日") {
|
|
22
|
-
value = ymd + "(" weekstr + ")"
|
|
22
|
+
value = ymd + "(" + weekstr + ")"
|
|
23
23
|
}
|
|
24
24
|
message += "\n■" + item + "\n" + value;
|
|
25
25
|
}
|
1
修正
answer
CHANGED
|
@@ -17,7 +17,7 @@
|
|
|
17
17
|
|
|
18
18
|
if (item == "タイムスタンプ"){
|
|
19
19
|
var hms = Utilities.formatDate(value, "Asia/Tokyo", "HH:mm:ss");
|
|
20
|
-
value = ymd + "(" weekstr + ") " + hms
|
|
20
|
+
value = ymd + "(" + weekstr + ") " + hms;
|
|
21
21
|
}else if (item == "出勤日" || item == "退勤日") {
|
|
22
22
|
value = ymd + "(" weekstr + ")"
|
|
23
23
|
}
|