Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function storeProductsES014() {
- Logger.clear();
- var sheet = SpreadsheetApp.getActiveSheet();
- var data = sheet.getDataRange().getValues();
- var NumStore = [];
- var NameStore = [];
- var DateStore = [];
- var QuantityStore = [];
- var count = 0;
- var test;
- var date;
- for(var i = 1; i < data.length; i++) {
- test = data[i][2].valueOf().substring(0,5);
- if(test === "ES014")
- {
- DateStore[count] = data[i][0].valueOf();
- NameStore[count] = data[i][1].valueOf();
- NumStore[count] = data[i][2].valueOf();
- QuantityStore[count] = data[i][3].valueOf();
- count++;
- }
- }
- for(i = 0; i < count.length; i++)
- {
- Logger.log(NumStore[i]);
- Logger.log(i);
- }
- createNew();
- var writeSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('ES014');
- for(i = 0; i < count; i++)
- {
- writeSheet.appendRow([DateStore[i], NameStore[i], NumStore[i], QuantityStore[i]]);
- }
- }
- function createNew() {
- var activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
- var yourNewSheet = activeSpreadsheet.getSheetByName("ES014");
- if (yourNewSheet != null) {
- activeSpreadsheet.deleteSheet(yourNewSheet);
- }
- yourNewSheet = activeSpreadsheet.insertSheet();
- yourNewSheet.setName("ES014");
- var sheet = SpreadsheetApp.getActiveSheet();
- sheet.appendRow(['Order Rec\'D Date', 'Cus Name', 'Part No', 'Quantity']);
- }
Add Comment
Please, Sign In to add comment