回答編集履歴
2
けしわすれ
answer
CHANGED
|
@@ -33,9 +33,7 @@
|
|
|
33
33
|
underneath.setValue(getCurrentTime());
|
|
34
34
|
}
|
|
35
35
|
function handleType2toSetDate(currentRange, next) {
|
|
36
|
-
Logger.log(currentRange.getColumn());
|
|
37
36
|
if(currentRange.getColumn() != 6) { return; }
|
|
38
|
-
Logger.log(next.getValue());
|
|
39
37
|
next.setValue(getCurrentTime());
|
|
40
38
|
}
|
|
41
39
|
|
1
じかんがたった
answer
CHANGED
|
@@ -16,4 +16,36 @@
|
|
|
16
16
|
var t = MM+"/"+dd+"_"+hh+":"+mm+"発表";
|
|
17
17
|
return t;
|
|
18
18
|
}
|
|
19
|
+
```
|
|
20
|
+
|
|
21
|
+
--- 追記
|
|
22
|
+
|
|
23
|
+
```javascript
|
|
24
|
+
//https://teratail.com/questions/132061
|
|
25
|
+
function onEdit(e) {
|
|
26
|
+
var sheetName = e.source.getSheetName();
|
|
27
|
+
if(sheetName === "テスト1") { handleType1toSetDate(e.range, e.range.getNextDataCell(SpreadsheetApp.Direction.DOWN)); }
|
|
28
|
+
if(sheetName === "テスト2") { handleType2toSetDate(e.range, e.range.getNextDataCell(SpreadsheetApp.Direction.NEXT)); }
|
|
29
|
+
return;
|
|
30
|
+
}
|
|
31
|
+
function handleType1toSetDate(currentRange, underneath) {
|
|
32
|
+
if(!currentRange.isPartOfMerge() || !underneath.isPartOfMerge()) { return; }
|
|
33
|
+
underneath.setValue(getCurrentTime());
|
|
34
|
+
}
|
|
35
|
+
function handleType2toSetDate(currentRange, next) {
|
|
36
|
+
Logger.log(currentRange.getColumn());
|
|
37
|
+
if(currentRange.getColumn() != 6) { return; }
|
|
38
|
+
Logger.log(next.getValue());
|
|
39
|
+
next.setValue(getCurrentTime());
|
|
40
|
+
}
|
|
41
|
+
|
|
42
|
+
function getCurrentTime() {
|
|
43
|
+
var ctime = new Date();
|
|
44
|
+
var MM = ctime.getMonth()+1;
|
|
45
|
+
var dd = ctime.getDate();
|
|
46
|
+
var hh = ctime.getHours();
|
|
47
|
+
var mm = ctime.getMinutes();
|
|
48
|
+
var t = MM+"/"+dd+"_"+hh+":"+mm+"発表";
|
|
49
|
+
return t;
|
|
50
|
+
}
|
|
19
51
|
```
|