function newFormEntry(e) {
  //trigger when linked form is submitted: [timestamp, team, name, pom count]
  Logger.log(e);

  //var logSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Current Log");
  var teamSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Current Teams");
  var teamOne = teamSheet.getRange('A1').getValue();
  var teamTwo = teamSheet.getRange('D1').getValue();
  var teamThree = teamSheet.getRange('G1').getValue();
  var teamFour = teamSheet.getRange('J1').getValue();

  //var newTeam = logSheet.getRange(logSheet.getLastRow(), 2);
  var newTeam = e.values[1];
  //var newName = logSheet.getRange(logSheet.getLastRow(), 3);
  var newName = e.values[2];
  //var newPoms = logSheet.getRange(logSheet.getLastRow(), 4);
  var newPoms = e.values[3];

  //push raw --> results with roll
  for (var x = 0; x < newPoms; x++) {
    if (newTeam = teamOne) {
      jumpNext(teamSheet, 1).setValue(newName);
      jumpNext(teamSheet, 3).setValue(rnJesus());
    }
    else if (newTeam = teamTwo) {
      jumpNext(teamSheet, 4).setValue(newName);
      jumpNext(teamSheet, 6).setValue(rnJesus());
    }
    else if (newTeam = teamThree) {
      jumpNext(teamSheet, 7).setValue(newName);
      jumpNext(teamSheet, 9).setValue(rnJesus());
    }
    else {
      jumpNext(teamSheet, 10).setValue(newName);
      jumpNext(teamSheet, 12).setValue(rnJesus());
    }
  }

  teamSheet.setActiveSelection('M20').setValue(newPoms);
  //at end time, unlink form from raw ==> MANUAL
  //after end time, push results to leaderboards ==> MANUAL

}

function jumpNext(sheet, column) {
  //sets next empty cell in given column as active
  return sheet.setActiveSelection(sheet.getRange(sheet.getDataRange().getHeight()+1, column));
}

function rnJesus() {
  //returns random loaded result
  var x = Math.floor(Math.random() * 25);
  if (x < 2)
    return 0;
  else if (x < 5)
    return 1;
  else if (x < 9)
    return 5;
  else if (x < 14)
    return 10;
  else if (x < 19)
    return 20;
  else if (x < 23)
    return 50;
  else if (x < 24)
    return 100;
  else
    return 1000;
}