Guest User

Google Sheets Script

a guest
Apr 3rd, 2018
228
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function storeProductsES014() {
  2.   Logger.clear();
  3.   var sheet = SpreadsheetApp.getActiveSheet();
  4.   var data = sheet.getDataRange().getValues();
  5.   var NumStore = [];
  6.   var NameStore = [];
  7.   var DateStore = [];
  8.   var QuantityStore = [];
  9.   var count = 0;
  10.   var test;
  11.   var date;
  12.   for(var i = 1; i < data.length; i++) {
  13.     test = data[i][2].valueOf().substring(0,5);
  14.     if(test === "ES014")
  15.     {
  16.        DateStore[count] = data[i][0].valueOf();
  17.        NameStore[count] = data[i][1].valueOf();
  18.        NumStore[count] = data[i][2].valueOf();
  19.        QuantityStore[count] = data[i][3].valueOf();
  20.        count++;
  21.     }
  22.    }
  23.  
  24.   for(i = 0; i < count.length; i++)
  25.   {
  26.       Logger.log(NumStore[i]);
  27.       Logger.log(i);
  28.   }
  29.  
  30.   createNew();
  31.   var writeSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('ES014');
  32.   for(i = 0; i < count; i++)
  33.   {
  34.       writeSheet.appendRow([DateStore[i], NameStore[i],  NumStore[i], QuantityStore[i]]);
  35.   }
  36.  
  37. }
  38. function createNew() {
  39.     var activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  40.     var yourNewSheet = activeSpreadsheet.getSheetByName("ES014");
  41.     if (yourNewSheet != null) {
  42.         activeSpreadsheet.deleteSheet(yourNewSheet);
  43.     }
  44.  
  45.     yourNewSheet = activeSpreadsheet.insertSheet();
  46.     yourNewSheet.setName("ES014");
  47.     var sheet = SpreadsheetApp.getActiveSheet();
  48.     sheet.appendRow(['Order Rec\'D Date', 'Cus Name', 'Part No', 'Quantity']);
  49. }
Add Comment
Please, Sign In to add comment