14b Assignments (Move to individual sheets)

14b-Assignments

function assignments() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();

//Get assignment  
  var fr = ss.getSheetByName("Assignment1");
  var lastRowValues = fr.getRange(fr.getLastRow(), 1, 1, fr.getLastColumn()).getValues(); 

//Get the sheet of the student who's just submitted and append their assignment on that sheet
  var sheets = ss.getSheets();
  for (var sh = 0 ; sh < sheets.length ; sh++) {
   var sheetName = sheets[sh].getSheetName();
   if(lastRowValues[0][1] === sheetName){
    ss.getSheetByName(sheetName).appendRow(lastRowValues[0]);
   }
  }
}