質問編集履歴

2

s

2019/02/02 08:11

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -26,17 +26,27 @@
26
26
 
27
27
  var SPREADSHEET_MEMBERS_SHEET = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Member');
28
28
 
29
+ var name = googleForm.name(e);
30
+
31
+
32
+
33
+ function spreadsheet_valueWith() {
34
+
35
+ var value = SPREADSHEET_MEMBERS_SHEET.getValues();
36
+
37
+ return value;
38
+
39
+ }
40
+
29
41
 
30
42
 
31
43
  var spreadsheet = {
32
44
 
33
- getChatworkId: function(name, SPREADSHEET_MEMBERS_SHEET) {
45
+ getChatworkId: function(name) {
34
46
 
35
- var name = googleForm.getApplicant(e);
47
+ var peopleWithValue = spreadsheet_valueWith();
36
48
 
37
- var peopleWithValue = spreadsheet_valueWith(SPREADSHEET_MEMBERS_SHEET);
38
-
39
- for(var i = 0; i < peopleWithValue.length; i++) {
49
+ for(var i = 2; i < peopleWithValue.length; i++) {
40
50
 
41
51
  var person = peopleWithValue[i];
42
52
 

1

2019/02/02 08:11

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -76,9 +76,9 @@
76
76
 
77
77
  },
78
78
 
79
- getBorrow: function(e) {
79
+ getDo: function(e) {
80
80
 
81
- var value = e.namedValues["る本"][0];
81
+ var value = e.namedValues["たいこと"][0];
82
82
 
83
83
  return value;
84
84