mercredi 25 mars 2020

Using the Code Below which works I need to add another function that only moves the data in Cell A and an entire row if a checkbox is checked

Using the Code Below which works I need to add another function that does everything the else if statement does but rather then moving the entire row of data to another sheet I only need to move data from cell A.

I also need to add a function that will move the entire row of data if a checkbox is checked.

function onEdit(e) { 
      if (e.value === 'COMPLETED FAB') {
        var sheet = e.range.getSheet();
        if (sheet.getSheetName() == 'Fabrication') {                     
          logSheet = e.source.getSheetByName('Fabrication Completed');    
          var row = e.range.getRow(); 
          var lastRow = logSheet.getLastRow();
          var range = sheet.getRange(row, 1, 1, sheet.getLastColumn()); 
          range.copyTo(logSheet.getRange(lastRow + 1, 1));
          sheet.deleteRow(row);

        }
      }

      else if (e.value === 'FINISHED') {
        var sheet = e.range.getSheet();
        if (sheet.getSheetName() == 'Service') {                     
          logSheet = e.source.getSheetByName('Service Completed');   
          var row = e.range.getRow(); 
          var lastRow = logSheet.getLastRow();
          var range = sheet.getRange(row, 1, 1, sheet.getLastColumn()); 
          range.copyTo(logSheet.getRange(lastRow + 1, 1));
          sheet.deleteRow(row);

        }
      }

      else if (e.value === 'SURV COMP') {
        var sheet = e.range.getSheet();
        if (sheet.getSheetName() == 'Surveys') {                     
          logSheet = e.source.getSheetByName('Surveys Completed');    
          var row = e.range.getRow(); 
          var lastRow = logSheet.getLastRow();
          var range = sheet.getRange(row, 1, 1, sheet.getLastColumn()); 
          range.copyTo(logSheet.getRange(lastRow + 1, 1));
          sheet.deleteRow(row);

        }
      }

    }

Aucun commentaire:

Enregistrer un commentaire