質問編集履歴
2
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -18,7 +18,7 @@
|
|
|
18
18
|
}
|
|
19
19
|
|
|
20
20
|
function SelectData( form ) {
|
|
21
|
-
var ss = SpreadsheetApp.openById('
|
|
21
|
+
var ss = SpreadsheetApp.openById('シートID'); //スプレッド取得
|
|
22
22
|
var sheet = ss.getSheetByName("データベース"); //シート取得
|
|
23
23
|
var lastRow=sheet.getLastRow();
|
|
24
24
|
|
1
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -22,7 +22,7 @@
|
|
|
22
22
|
var sheet = ss.getSheetByName("データベース"); //シート取得
|
|
23
23
|
var lastRow=sheet.getLastRow();
|
|
24
24
|
|
|
25
|
-
|
|
25
|
+
Logger.log(form.selectindex);
|
|
26
26
|
|
|
27
27
|
var j=0;
|
|
28
28
|
var values = [];
|
|
@@ -31,7 +31,7 @@
|
|
|
31
31
|
var val = sheet.getRange(i, 8).getValue();
|
|
32
32
|
|
|
33
33
|
if ( val == form.selectindex ) {
|
|
34
|
-
values[j]
|
|
34
|
+
values[j]=sheet.getRange(i,1,1,8).getValues();
|
|
35
35
|
j++;
|
|
36
36
|
}
|
|
37
37
|
}
|
|
@@ -42,6 +42,7 @@
|
|
|
42
42
|
}
|
|
43
43
|
|
|
44
44
|
|
|
45
|
+
|
|
45
46
|
### index.html
|
|
46
47
|
|
|
47
48
|
<!DOCTYPE html>
|