function interview(){
  var ss = SpreadsheetApp.getActiveSheet();
  var id = SpreadsheetApp.getActive().getId();
  var username = ss.getRange("C4").getValue();
  var score = ss.getRange("F45").getValue();
  var acc = ss.getRange("G46").getValue();
  var steamId = ss.getRange("C6").getValue();
  var discordId = ss.getRange("C5").getValue();
  var interviewer = ss.getRange("C7").getValue();
  var currentfileId = SpreadsheetApp.getActiveSpreadsheet().getId();
  var target = SpreadsheetApp.openById("1WJgDS7HQ-LfRG2UmBT9Qb83WrP41izhVGqgJIoTqDI8");
  var datePassed = ss.getRange("F4").getValue();
  var check = ss.getRange("C49").getValue();
  var text = "LINK";
  var list = "LIST";
  var passedVals = [ [username, datePassed, discordId, steamId, interviewer] ];
  var title = ss.getRange("C8").getValue();

  if(score > 77 || acc == "Accepted"){
    if(check != "Results sent to Database!"){
      var specific_sheet = target.getSheetByName("Students");
      var sheetid = SpreadsheetApp.getActiveSheet().getSheetId();
      specific_sheet.insertRowsBefore(4, 1);
      specific_sheet.getRange("B4:F4").setValues(passedVals);
      ss.getRange("C49").setValue("Results sent to Database!");
      specific_sheet.getRange("V4").setFormula("=(TODAY()-C4)");
      specific_sheet.getRange("W4").setFormula("=IF(AND(H4=\"TRUE\";K4=\"TRUE\";N4=\"PASSED\";R4>=2);\"✔\";\"✘\")");

      var interview_s = target.getSheetByName("HideInterviews");
      interview_s.insertRowsBefore(1, 1);
      interview_s.getRange("A1").setValue(interviewer);
      interview_s.getRange("B1").setValue(datePassed);
      interview_s.getRange("C1").setValue(username);
      interview_s.getRange("D1").setValue(discordId);
      interview_s.getRange("E1").setValue(steamId);
      interview_s.getRange("F1").setValue(score);
      interview_s.getRange("G1").setFormula("=hyperlink(\""+SpreadsheetApp.getActiveSpreadsheet().getUrl()+"\";\"LINK\")");
      interview_s.getRange("H1").setValue(acc);

      ss.getRange("C49").setValue("Results sent to Database!");
      ss.getRange("F5").setValue(datePassed);
      SpreadsheetApp.getActiveSpreadsheet().setName(title);

      movesheet();
    }
  }
}

function onOpen() {
  if(SpreadsheetApp.getActiveSpreadsheet().getName() == "Interview Sheet - Copy this!" || SpreadsheetApp.getActiveSpreadsheet().getName() == "Backup Sheet"){
    SpreadsheetApp.getUi().alert("Warning","Do not edit this sheet! Make a NEW copy",SpreadsheetApp.getUi().ButtonSet.OK);
  }
}

function movesheet(){
  var ss = SpreadsheetApp.getActiveSheet();
  var check = ss.getRange("C49").getValue();
  var accOrDec = ss.getRange("G46").getValue();
  var currentfileId = SpreadsheetApp.getActiveSpreadsheet().getId();
  var accFold = DriveApp.getFolderById("1Pj6liM7sT73ankycBkcNXDHYL71YtvvC"); //Accepted folder
  var decFold = DriveApp.getFolderById("1krxO7nuLI3l81YsSu_UkqZvHO6J8hpZN"); //Failed folder
  var curFold = DriveApp.getFolderById("1xC9GC3rYNILGhOnH7VY8W4cFUOkJ6EQr"); //Current


  if(check == "Arrow finished!"){
    if(accOrDec == "Accepted"){
     accFold.addFile(DriveApp.getFileById(currentfileId));
     curFold.removeFile(DriveApp.getFileById(currentfileId));
      SpreadsheetApp.getUi().alert("RTO Interview","The sheet has been moved to the ACCEPTED folder.",SpreadsheetApp.getUi().ButtonSet.OK);
      SpreadsheetApp.getActiveSpreadsheet().toast("The sheet has been moved to the ACCEPTED folder.","RTO Interview",-1);
    }
    if(accOrDec == "Declined"){
     decFold.addFile(DriveApp.getFileById(currentfileId));
     curFold.removeFile(DriveApp.getFileById(currentfileId));
      SpreadsheetApp.getUi().alert("RTO Interview","The sheet has been moved to the FAILED folder.",SpreadsheetApp.getUi().ButtonSet.OK);
      SpreadsheetApp.getActiveSpreadsheet().toast("The sheet has been moved to the FAILED folder.","RTO Interview",-1);
    }
  }
}

function setOwner(){
  var ss = SpreadsheetApp.getActiveSheet();
  var files = DriveApp.getFilesByName(ss.getName());
  while (files.hasNext()){
    var file = files.next();
    var owner = file.setOwner("viktor.melon@gmail.com");
  }
}