function myFunction() { var AUTOINC_COLUMN = 0; var HEADER_ROW_COUNT = 1; var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); var worksheet = spreadsheet.getSheetByName("Sheet1"); var rows = worksheet.getDataRange().getNumRows(); var vals = worksheet.getSheetValues(1, 1, rows+1, 2); for (var row = HEADER_ROW_COUNT; row < vals.length; row++) { try { var id = vals[row][AUTOINC_COLUMN]; Logger.log(id);Logger.log((""+id).length ===0); if ((""+id).length === 0) { // Here the columns & rows are 1-indexed worksheet.getRange(row+1, AUTOINC_COLUMN+1).setValue(row); } } catch(ex) { // Keep calm and carry on } } }
function myFunction() { var AUTOINC_COLUMN = 0; var HEADER_ROW_COUNT = 1; var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); var worksheet = spreadsheet.getSheetByName("Blad1"); var rows = worksheet.getDataRange().getNumRows(); var vals = worksheet.getSheetValues(1, 1, rows+1, 2); for (var row = HEADER_ROW_COUNT-1; row < vals.length-1; row++) { try { var id = vals[row][AUTOINC_COLUMN]; Logger.log(id);Logger.log((""+id).length ===0); if ((""+id).length === 0) { // Here the columns & rows are 1-indexed worksheet.getRange(row+1, AUTOINC_COLUMN+1).setValue(row); } } catch(ex) { // Keep calm and carry on } } }
function myFunction() { var AUTOINC_COLUMN = 0; var HEADER_ROW_COUNT = 1; var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); var worksheet = spreadsheet.getSheetByName("Blad1"); var rows = worksheet.getDataRange().getNumRows(); var vals = worksheet.getSheetValues(1, 1, rows+1, 2); for (var row = HEADER_ROW_COUNT-1; row < vals.length-1; row++) { try { var id = vals[row][AUTOINC_COLUMN]; Logger.log(id);Logger.log((""+id).length ===0); if ((""+id).length === 0) { // Here the columns & rows are 1-indexed worksheet.getRange(row+1, AUTOINC_COLUMN+1).setValue(row); } } catch(ex) { // Keep calm and carry on } } }
function myFunction() { var AUTOINC_COLUMN = 0; var HEADER_ROW_COUNT = 1; var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); var worksheet = spreadsheet.getSheetByName("Sheet1"); var rows = worksheet.getDataRange().getNumRows(); var vals = worksheet.getSheetValues(1, 1, rows+1, 2); for (var row = HEADER_ROW_COUNT; row < vals.length; row++) { try { var id = vals[row][AUTOINC_COLUMN]; Logger.log(id);Logger.log((""+id).length ===0); if ((""+id).length === 0) { // Here the columns & rows are 1-indexed worksheet.getRange(row+1, AUTOINC_COLUMN+1).setValue(row-1); } } catch(ex) { // Keep calm and carry on } } }
Flashback finansieras genom donationer från våra medlemmar och besökare. Det är med hjälp av dig vi kan fortsätta erbjuda en fri samhällsdebatt. Tack för ditt stöd!
Swish: 123 536 99 96 Bankgiro: 211-4106
Flashback finansieras genom donationer från våra medlemmar och besökare. Det är med hjälp av dig vi kan fortsätta erbjuda en fri samhällsdebatt. Tack för ditt stöd!
Swish: 123 536 99 96 Bankgiro: 211-4106