Search code examples
google-sheetsrow

Skip empty value in Google Sheets


I have running script in google sheets for submitting data, but I have no idea how to skip empty values

Here is my script :

function SubmitData() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var formS = ss.getSheetByName("FORM");
  var dataS= ss.getSheetByName("DATA");
  
  var values = formS.getRange(8,1,20,5).getValues();
  dataS.getRange(dataS.getLastRow()+1,3,20,5).setValues(values);
  
} 

Thank You


Solution

  •   var values = formS.getRange(8,1,20,5).getValues();
      values = values.filter(e=>e.join('') !== '');
      dataS.getRange(dataS.getLastRow()+1,3,values.length,5).setValues(values);