this is my sample script that append rows based on my data my script work fine and my second appendrow is my backup data incase something is missing. i would like to add another append row but this time around i want to append row if only A1=”cat”” if it not cat then it wont append row on my backupsheet
var values = templateSheet.getRange('A14:H40').getValues();
for (var i = 0; i < values.length; i++) {
if (values[i][0].toString().trim() != '') {
var QTY = values[i][0];
var UNIT = values[i][1];
var ITEM = values[i][2];
var ABC = values[i][6];
var TOTALZZ = values[i][4];
var REMARK = values[i][5];
summarySheet.appendRow([CHECK,PODATE,PO,QTY,UNIT,ITEM,TOTALZZ,REMARK,FROM,DELIVEREDTO,ABC,RS,DRIVER,CHECKBY,DELIVERYDATE,Approvedby]);
backupsheet.appendRow([CHECK,PODATE,PO,QTY,UNIT,ITEM,TOTALZZ,REMARK,FROM,DELIVEREDTO,ABC,RS,DRIVER,CHECKBY,DELIVERYDATE,Approvedby]);