notifyOrdersAppearCompleted

notifyOrdersAppearCompleted.js

function notifyOrdersAppearCompleted() {
  var curHour = new Date().getHours();
  var notifiedCell = sheet.getRange("F3").getValues()[0][0];

  if (notifiedCell == true) {
    return
  }

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

  var values = sheet.getRange(startRow,1,rowRange,1).getValues();

  for (var i = 0; i < values.length; i++) {
    var completed = values[i][0];
    
    if (completed == false) {
      return
    }
  }

  triggerSlackRequest(completedOrdersUser,"Hey, Looks like lunch orders are fully completed.\n" + sheetURL);
  // So that adele isn't spammed every 5 minutes.
  sheet.getRange("F3").setValue("true")
}