lunchReminder

lunchReminder.js

function lunchReminder() {
  var curHour = new Date().getHours();

  if (curHour > 17 || curHour < 9) {
    Logger.log("Outside work hours stopping");
    return
  }

  var completedValues = sheet.getRange(startRow,1,rowRange,1).getValues();
  var slackNames = sheet.getRange(startRow,2,rowRange,1).getValues();
  
  // Loop over the completed rows
  for (var i = 0; i < completedValues.length; i++) {
    var completed = completedValues[i][0];

    if(completed !== "" && completed == false) {
      var name = slackNames[i][0];
      triggerSlackRequest("@"+name,"*You haven't completed your lunch order*, don't miss out - order now!\n" + sheetURL);
    }
  }
};