質問編集履歴

code

2020/04/03 05:43

投稿

スコア59

title CHANGED Viewed

File without changes

body CHANGED Viewed

@@ -2,27 +2,31 @@
 Macbook pro. Google spread sheet , google apps script
 ```ここに言語を入力
-function Slack() {
+function SlackPTR() {
   var ss = SpreadsheetApp.getActiveSpreadsheet();
-  var sh = ss.getSheetByName("xxx");
+  var sh = ss.getSheetByName("test");
   var data = sh.getDataRange().getValues();
   var lastRow = sh.getLastRow();
   for(let i = 1; i <= lastRow; i++) {
   var sentence=sh.getRange(i, 1).getValue();
+ const q251046 = (e) => {
+    if(!e.value) return;
+    const rng = e.range;
+    const c = rng.getColumn();
+    if(c !== 3) return;
- var payload  = {
+    const payload  = {
-    'text'      : sentence,
+        'text':e.value,
-  };
+    };
-  var options = {
+    const options = {
-    'method'      : 'post'                 ,
+        'method':'post',
-    'contentType' : 'application/json'     ,
+        'contentType':'application/json',
-    'payload'     : JSON.stringify(payload),
+        'payload':JSON.stringify(payload),
-  };
+    };
-  var url = 'xxxx';
+    const url = 'xxx';
-  UrlFetchApp.fetch(url, options);
+    UrlFetchApp.fetch(url, options);
-}}
+}}}
 ```
 スプレッドシート 内容