// Function 3 "On Edit"
//
// function combines 2 cells by adding them
//
function addCellsIntermediate()
{

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Reactions');
  var currentUser = sheet.getRange('H25').getValue();

  // find currentUser on list
  var index = 4
    for (index; index < 24; index++) {
      var valueFromList = sheet.getRange(index, 22).getValue();

        if (currentUser == 0){
          break;
        }
        else if (valueFromList == currentUser) {
          break;
        }
     }


  //selects the ranges for the function
  for (i = 7; i < 7+21; i++) {
      var num1 = sheet.getRange(i,13).getValue();
      var num2 = sheet.getRange(i,14).getValue();

    //check for num2=integer and num2>0
    if(num2 % 1 === 0 && num2 > 0) {

      //success, but missing input
      if (currentUser == 0){
       Browser.msgBox('Bitte in Zelle H25 deinen Namen auswählen und erneut versuchen.')
       sheet.getRange(i,14).clear({contentsOnly: true});
       sheet.getRange('H25').setBackground('red');
       SpreadsheetApp.flush();
      }

      //success, pls confirm
      else{
       var confirm = Browser.msgBox(String(num2)+' Reactions für "'+String(currentUser)+'" als gestartet eintragen?', Browser.Buttons.YES_NO);

        // Process the user's response.
        if (confirm == 'yes'){
          sheet.getRange(i,13).setValue(num1+num2);
          sheet.getRange(i,14).clear({contentsOnly: true});
          //apply reactionpoints for currentUser
          var tempCell = sheet.getRange(index, 23).getValue();
          sheet.getRange(index, 23).setValue(tempCell + num2);
        }

        else {
        sheet.getRange(i,14).clear({contentsOnly: true});
        }
      }
    }
    //if "0" or cell=empty, proceed
    else if (num2 == 0 || num2 == null) {
      continue;
    }

    //else, invalid entry
    else {
      Browser.msgBox('Eingabe unzulässig.');
      sheet.getRange(i,14).clear({contentsOnly: true});
    }
  }
}