Google app Script get range copy data if cell not blank

Question

I have a script someone else created, I am new to app script and still learning, I am copying a range of data from sheet1 that they fill in daily to sheet2, I would like this to not copy the row if Column F is blank. Here is what I am using currently.

       function CopyData(CopyData) {

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet1 = ss.getSheetByName("2019-02-03");
  var sheet2 = ss.getSheetByName("Archive Data");

  sheet1.getRange("A2:Q16").copyTo(sheet2.getRange(sheet2.getLastRow()+1,1,1,1), {contentsOnly:true});

}

Read about conditional logic in javascript – tehhowch Feb 04 '19 at 13:52 — tehhowch, Feb 04 '19 at 13:52
Thank you , I will definitely read up on it. – Jim Spalding Feb 04 '19 at 22:03 — Jim Spalding, Feb 04 '19 at 22:03

score 0 · Accepted Answer · answered Feb 04 '19 at 18:52

0

Try this:

function CopyData(CopyData) {
  var ss=SpreadsheetApp.getActive();
  var sh1=ss.getSheetByName("2019-02-03");
  var sh2=ss.getSheetByName("Archive Data");
  var rg1=sh1.getRange("A2:Q16");
  var vA=rg1.getValues();
  for(var i=0;i<vA.length;i++){
    if(vA[i][5]){
      sh2.appendRow(vA[i]);
    }
  }
}

answered Feb 04 '19 at 18:52

Cooper

59,616
6
23
54

Worked perfectly, thank you for quick response. I learn more everyday. – Jim Spalding Feb 04 '19 at 21:40

Google app Script get range copy data if cell not blank

1 Answers1