質問編集履歴
2
response対象を修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -165,4 +165,34 @@
|
|
|
165
165
|
var bodyPublic = body + "被験者ID:" + date + "\n予約日:" + name + "\n曜日:" + language + "\n検査名:" + language + "\n備考１:" + language + "\n備考２:" + language ;
|
|
166
166
|
sendToSlack(bodyPublic, "#16-会議メンバー共有事項");
|
|
167
167
|
}
|
|
168
|
+
```
|
|
169
|
+
|
|
170
|
+
### ”●●● = response” の●●●部分を修正したら反映出来ました
|
|
171
|
+
```
|
|
172
|
+
switch (title) {
|
|
173
|
+
case "被験者ID":
|
|
174
|
+
date = response;
|
|
175
|
+
break;
|
|
176
|
+
case "予約日":
|
|
177
|
+
name = response;
|
|
178
|
+
break;
|
|
179
|
+
case "曜日":
|
|
180
|
+
language = response;
|
|
181
|
+
break;
|
|
182
|
+
case "検査名":
|
|
183
|
+
kensamei = response;
|
|
184
|
+
break;
|
|
185
|
+
case "備考１":
|
|
186
|
+
bikou1 = response;
|
|
187
|
+
break;
|
|
188
|
+
case "備考２":
|
|
189
|
+
bikou2 = response;
|
|
190
|
+
break;
|
|
191
|
+
default:
|
|
192
|
+
break;
|
|
193
|
+
}
|
|
194
|
+
}
|
|
195
|
+
var bodyPublic = body + "被験者ID:" + date + "\n予約日:" + name + "\n曜日:" + language + "\n検査名:" + kensamei + "\n備考１:" + bikou1 + "\n備考２:" + bikou2 ;
|
|
196
|
+
sendToSlack(bodyPublic, "#16-会議メンバー共有事項");
|
|
197
|
+
}
|
|
168
198
|
```
|
1
Webhook URLの後ろのスペースを削除しました
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -110,4 +110,59 @@
|
|
|
110
110
|
|
|
111
111
|
|
|
112
112
|
|
|
113
|
+
### 修正したところ、Googleフォーム送信時に内容が連携されましたが、response内容が誤って反映されます
|
|
114
|
+
```
|
|
115
|
+
function sendToSlack(body, channel) {
|
|
116
|
+
var url = "https://hooks.slack.com/services/●●●●●";
|
|
117
|
+
var data = { "channel" : channel, "username" : "ネコちゃん", "text" : body, "icon_emoji" : ":date: " };
|
|
118
|
+
var payload = JSON.stringify(data);
|
|
119
|
+
var options = {
|
|
120
|
+
"method" : "POST",
|
|
121
|
+
"contentType" : "application/json",
|
|
122
|
+
"payload" : payload
|
|
123
|
+
};
|
|
124
|
+
var response = UrlFetchApp.fetch(url, options);
|
|
125
|
+
}
|
|
126
|
+
|
|
127
|
+
function test() {
|
|
128
|
+
sendToSlack("テスト通知確認です", "#16-会議メンバー共有事項");
|
|
129
|
+
}
|
|
130
|
+
|
|
131
|
+
function onFormSubmit(e){
|
|
132
|
+
|
|
133
|
+
var body = "<! @●●● >心理検査が予約されました！\n";
|
|
134
|
+
var applicant = "";
|
|
135
|
+
var itemResponse = e.response.getItemResponses();
|
|
136
|
+
|
|
137
|
+
for (var j = 0; j < itemResponse.length; j++){
|
|
138
|
+
var formData = itemResponse[j];
|
|
139
|
+
var title = formData.getItem().getTitle();
|
|
140
|
+
var response = formData.getResponse();
|
|
141
|
+
|
|
142
|
+
switch (title) {
|
|
143
|
+
case "被験者ID":
|
|
144
|
+
date = response;
|
|
113
|
-
|
|
145
|
+
break;
|
|
146
|
+
case "予約日":
|
|
147
|
+
name = response;
|
|
148
|
+
break;
|
|
149
|
+
case "曜日":
|
|
150
|
+
language = response;
|
|
151
|
+
break;
|
|
152
|
+
case "検査名":
|
|
153
|
+
language = response;
|
|
154
|
+
break;
|
|
155
|
+
case "備考１":
|
|
156
|
+
language = response;
|
|
157
|
+
break;
|
|
158
|
+
case "備考２":
|
|
159
|
+
language = response;
|
|
160
|
+
break;
|
|
161
|
+
default:
|
|
162
|
+
break;
|
|
163
|
+
}
|
|
164
|
+
}
|
|
165
|
+
var bodyPublic = body + "被験者ID:" + date + "\n予約日:" + name + "\n曜日:" + language + "\n検査名:" + language + "\n備考１:" + language + "\n備考２:" + language ;
|
|
166
|
+
sendToSlack(bodyPublic, "#16-会議メンバー共有事項");
|
|
167
|
+
}
|
|
168
|
+
```
|