supernovaplus

function companyBankVouchersMove() {
  var initialScanLocation = 69;
  var spreadsheet = SpreadsheetApp.openById("-");
  
  
  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Company Bank'), true);
  var column = spreadsheet.getRange('D'+initialScanLocation+':D');
  var values = column.getValues(); // get all data in one call
  
  var location = 0;

supernovaplus

function MoveBatEmployeesInactiveSheetWhoLeftCompany() {
  var console = {log: function(item){return Logger.log(item)}}
  var spreadsheet = SpreadsheetApp.getActive();
  var sheet1 = spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Vouchers'), true);
  
  var ActiveEmployeeArray = sheet1.getRange('S4:S132').getValues().filter(function(item){return item[0]!="";})
  
  var sheet2 = spreadsheet.setActiveSheet(spreadsheet.getSheetByName('InactiveList'), true);
  
  var ScanningThisArray = sheet2.getRange('I2:I173').getValues();

supernovaplus

function fireselected(){
  var spreadsheet = SpreadsheetApp.getActive();
//Logger.log(spreadsheet.getName());

  
  if(spreadsheet.getSheetName()!=="Vouchers")return Logger.log("not vouchers page");
  if(spreadsheet.getActiveRange().getColumn() !== 2)return Logger.log("not second column");
  if(!spreadsheet.getActiveRange().getValue().match(/#/g))return Logger.log("wrong cell");
  

supernovaplus

function LogAllTriggers() {
  var allTriggers = ScriptApp.getProjectTriggers();
  if(allTriggers.length<1)return Logger.log("list is empty");
  Logger.log("Trigers Count: "+allTriggers.length);
  for (var i = 0; i < allTriggers.length; i++) {
    Logger.log(i+1+"->"+allTriggers[i].getHandlerFunction()+"=>"+allTriggers[i].getTriggerSource()+"=>"+allTriggers[i].getUniqueId()+"=>"+JSON.stringify(allTriggers[i].getEventType()));
  }
}

supernovaplus

function DeleteAllTriggers() {
  var allTriggers = ScriptApp.getProjectTriggers();
  if(allTriggers.length<1)return Logger.log("list is empty");
  Logger.log("Deleted => "+allTriggers.length);
  for (var i = 0; i < allTriggers.length; i++) {
    ScriptApp.deleteTrigger(allTriggers[i]);
  }
}