sldsignups.gs

// Script by Arman B. for ASL's SLD department.
// 6 sign-ups per a block, multiplied by 4 blocks per a day, is about 50 - combined with extra sign-ups, so the range should really be up to 50.
function onEdit() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  var range = sheet.getRange("A2:G100");
  var data = sheet.getDataRange().getValues();
  
  range.sort([{column: 4, ascending: true}]);  
  
  var todayDate = new Date();
  // Make sure that column 3 is always formatted as a date.
  for(var I = 1; I < 100; I++) {
    if(data[3][I].valueOf() < todayDate.valueOf()) {
      deleteRow(I);
    }
  }
}