function myFunction() {
  Logger.log("yo");
}

function checkRowValidity() {
  var sheetVendite = SpreadsheetApp.getActive().getSheetByName("VENDITE");
  var activeRow = sheetVendite.getActiveRange();
  var value = sheetVendite.getRange(activeRow, getRowIndex(), 6).getValue();
  Logger.log(value);
}
function onEdit(e){
  var sheetVendite = SpreadsheetApp.getActive().getSheetByName("VENDITE");
  var sheetProdotti = SpreadsheetApp.getActive().getSheetByName("PRODOTTI");

  //vars Vendite
  var activeRow = sheetVendite.getActiveRange();
  var date = sheetVendite.getRange(e.range.rowStart, 1);
  var product = sheetVendite.getRange(e.range.rowStart, 2);
  var daily_qty = sheetVendite.getRange(e.range.rowStart, 3);
  var remain_qty = sheetVendite.getRange(e.range.rowStart, 4);
  var profile_link = sheetVendite.getRange(e.range.rowStart, 5);
  var order_id = sheetVendite.getRange(e.range.rowStart, 6);
  var client_name = sheetVendite.getRange(e.range.rowStart, 7);
  var paypal_mail = sheetVendite.getRange(e.range.rowStart, 8);
  var review_link = sheetVendite.getRange(e.range.rowStart, 9);
  var perc_refund = sheetVendite.getRange(e.range.rowStart, 10);
  var agent = sheetVendite.getRange(e.range.rowStart, 11);
  var review = sheetVendite.getRange(e.range.rowStart, 12);
  var refund = sheetVendite.getRange(e.range.rowStart, 13);
  var fee = sheetVendite.getRange(e.range.rowStart, 14);

  //vars Prodotti
  var agents = {
    'bot': {
      name: 'BOT',
      daily_qty: sheetProdotti.getRange(3, 9).getValue()
    },
    'siscard': {
      name: 'SISCARD',
      daily_qty: sheetProdotti.getRange(4, 9).getValue()
    },
    'damiano': {
      name: 'DAMIANO',
      daily_qty: sheetProdotti.getRange(5, 9).getValue()
    }
  }

  //products 2 to 40
  var products = {};
  for(var i = 2; i <= 40; i++) {
    var name = sheetProdotti.getRange(i, 2).getValue();
    var total_qty = sheetProdotti.getRange(i, 5).getValue();
    products[name.replace(" ", "-").toLowerCase()] = { id: i, name: name, total_qty: total_qty };
  }

  if(SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getName() == "VENDITE") {
    var currentStatus = false;
    if(product.getValue() !== "" && typeof products[product.getValue().replace(" ", "-").toLowerCase()] === 'undefined') {
      product.setValue("PRODOTTO NON TROVATO");
      currentStatus = false;
    } else {
      var currentProduct = products[product.getValue().replace(" ", "-").toLowerCase()];
      if(agent.getValue() !== "" && typeof agents[agent.getValue().replace(" ", "-").toLowerCase()] !== 'undefined') {
        var currentAgent = agents[agent.getValue().replace(" ", "-").toLowerCase()];
        agent.setValue(currentAgent.name);
        daily_qty.setValue(currentAgent.daily_qty);
        remain_qty.setValue(currentProduct.total_qty - 1);
        if(profile_link.getValue() === "") {
          profile_link.setValue("PROFILO AMAZON MANCANTE");
          currentStatus = false;
        }
        if(date.getValue() === "")
          date.setValue("ERR");
        else if(order_id.getValue() === "")
          order_id.setValue("ERR");
        else if(client_name.getValue() === "")
          client_name.setValue("ERR");
        else if(paypal_mail.getValue() === "")
          paypal_mail.setValue("ERR");
        else if(perc_refund.getValue() === "")
          perc_refund.setValue("ERR");
      } else {
        agent.setValue("AGENTE NON TROVATO");
        currentStatus = false;
      }
    }
    if(date.getValue() != "ERR" && order_id.getValue() != "ERR" && client_name.getValue() != "ERR" && paypal_mail.getValue() != "ERR" && perc_refund.getValue() != "ERR" && order_id.getValue() != "") {
      currentStatus = true;
      var currentProductCell = sheetProdotti.getRange(i, currentProduct.id).setValue(remain_qty);
    }
    Logger.log(currentStatus);
  }
}