Excel Forum

Code: Select all

function getDatatest() 
{
  
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Database")
  var data = sheet.getDataRange().getValues();
  var token = ["token group1", "token group2"];
  
  
      var msg = '\n      ' + data[2][27] + '\n––––•(-• (Time line) •-)•––––\n\n'
      for (var i=3; i<18; i++) 
          {
            msg = msg + data[i][30] + '\n'  
          }          
      for(var j=0; j<token.length; j++)
          {
            sendLineNotify(msg, token[j]);
          }
          
     //แบ่งข้อมูลส่งรอบ 2     
     var msg2 = "\n"
      for (var k=18; k<data.length; k++) 
          {
            msg2 = msg2 + data[k][30] + '\n'  
          }          
      for(var l=0; l<token.length; l++)
          {
            sendLineNotify(msg2, token[l]);
          }
}


/////////////////////// send Multigroup
function sendLineNotify(message, token)      {
  var options =
   {
     "method"  : "post",
     "payload" : 
     {
       "message" : message,
     },
     "headers" : {"Authorization" : "Bearer " + token}
   };
   UrlFetchApp.fetch("https://notify-api.line.me/api/notify", options);
}

Code: Select all

if(data[i][30].length > 0){
   msg = msg + data[i][30] + '\n'
}

Code: Select all

function getDatatest() 
{  
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Database")
  var data = sheet.getDataRange().getValues();
  var token = ["token group1", "token group2"];
  
  
      var msg = '\n      ' + data[2][27] + '\n––––•(-• (Time line) •-)•––––\n\n'
      for (var i=3; i<18; i++) 
          {
            if(data[i][30].length > 0){        //ใส่ if ดักจับค่าว่าง
              msg = msg + data[i][30] + '\n'
             }
          }          
      for(var j=0; j<token.length; j++)
          {
            sendLineNotify(msg, token[j]);
          }
          
     //แบ่งข้อมูลส่งรอบ 2     
     var msg2 = '\n      ' + data[2][27] + '\n––––•(-• (Time line) •-)•––––\n\n'
      for (var k=18; k<32; k++) 
          {
            if(data[k][30].length > 0){        //ใส่ if ดักจับค่าว่าง
             msg2 = msg2 + data[k][30] + '\n'  
            }
          }          
      for(var l=0; l<token.length; l++)
          {
            sendLineNotify(msg2, token[l]);
          }
}
/////////////////////// send Multigroup
function sendLineNotify(message, token)      {
  var options =
   {
     "method"  : "post",
     "payload" : 
     {
       "message" : message,
     },
     "headers" : {"Authorization" : "Bearer " + token}
   };
   UrlFetchApp.fetch("https://notify-api.line.me/api/notify", options);
}