triggerRecorderCode.gs

function triggerRecorder(proc,stat) {
/*
関数の概要：
：triggerシートへの書き込み
*/
  var ss_key = PropertiesService.getScriptProperties().getProperty('sp_ss_key');
  var ss = SpreadsheetApp.openById(ss_key);
  var sheet = ss.setActiveSheet(ss.getSheetByName("trigger"));

  var lastrow = sheet.getLastRow();

  var myPROCNAME = proc;
  var mySTAT = stat;

  //初回時のみヘッダーを作成
  if( (myPROCNAME == "initProc") && (mySTAT == "STARTED") ){
    sheet.clear();
    lastrow = 1;
    sheet.getRange(lastrow,1,1,5).setValues([["時刻","処理","bgnPoint","endPoint","datListLength"]]);
  }

  var exec_date = new Date();
  exec_date = exec_date.toLocaleString();
  var exec_text = myPROCNAME + " " + mySTAT;

  //書き出し項目作成
  var output = [ [exec_date,
                  exec_text,
                  PropertiesService.getScriptProperties().getProperty('sp_bgnPoint'),
                  PropertiesService.getScriptProperties().getProperty('sp_endPoint'),
                  PropertiesService.getScriptProperties().getProperty('sp_datListLength')
                 ] ];

  //書き出し
  lastrow++;
  sheet.getRange(lastrow, 1,1,5).setValues(output);

  if( (myPROCNAME == "termProc") && (mySTAT == "ENDED") ){
    lastrow++;
    sheet.getRange(lastrow,1,1,5).setValues([[exec_date,"終了処理が無事終了しますた",0,0,0]]);
  }
}