What do you want to save?
Add Code snippet
New code examples
-
Other 2021-10-05 11:19:03
google script last row
var cells = sheetInput.getRange("a:a").getValues();//Gets all cells in col A. var filter = cells.filter((cell) => cell != "");//filters out the blanks. var lr = parseInt(filter.length) + 1;//This is the Last Row. ... Add solution -
Other 2021-09-29 22:40:05
Get Multipal Tab Value to One App Script
function saveRange(){ var ss=SpreadsheetApp.getActiveSpreadsheet(); var sheet=ss.getSheetByName('Sample_tab_1'); var range=sheet.getRange('A8:AE47').getValues(); sheet.getRange(sheet.getLastRow()+1, 1, range.length, range[0].length).setValues(ran... Add solution -
Javascript 2021-09-26 20:44:03
javascript get last row googlesheets
//****GLOBALS**** var SpreadsheetID = "1A7Ix7rzrhu7zBKcS7zPeU8w8c_nTae0mBHycvMUE68A"; var SheetName = "CleanData"; function myFunction() { var ss = SpreadsheetApp.openById(SpreadsheetID) var sheet = ss.ge... Add solution -
Go 2021-09-10 16:09:02
read every cell in a column google app script
function appendString() { var range = SpreadsheetApp.getActiveSheet().getActiveRange(); var values = range.getValues(); var modified = values.map(function (row) { return row.map(function (col) { return col + " string"; });... Add solution -
Other 2021-09-10 05:41:02
enum multiple values
public enum Language{ English("english", "eng", "en", "en_GB", "en_US"), German("german", "de", "ge"), Croatian("croatian", "hr", "cro&quo... Add solution -
Other 2021-08-30 04:34:02
find duplicates apps script
/** * Removes duplicate rows from the current sheet. */ function removeDuplicates() { var sheet = SpreadsheetApp.getActiveSheet(); var data = sheet.getDataRange().getValues(); var newData = []; for (var i in data) { var row = data[i]; va... Add solution