Skip to content

Instantly share code, notes, and snippets.

@kobeumut
Last active October 4, 2017 08:25
Show Gist options
  • Save kobeumut/5d5bbc2145c4d4cf593384783cdbd22c to your computer and use it in GitHub Desktop.
Save kobeumut/5d5bbc2145c4d4cf593384783cdbd22c to your computer and use it in GitHub Desktop.
Change row color and add this row in local data on Google Apps Script
function onEdit(e){
var getRow = e.source.getActiveRange().getRow().toFixed(0);
var newSheet=SpreadsheetApp.getActiveSpreadsheet().getSheets()[0]; //I Select First Sheet.
if(newSheet.getSheetId()==SpreadsheetApp.getActiveSheet().getSheetId()){
var rowrange =SpreadsheetApp.getActiveSheet().getDataRange().offset(getRow-1, 0, 1);
rowrange.setBackground("#49fff933");
var cache = PropertiesService.getUserProperties().getProperty("array");
PropertiesService.getUserProperties().setProperty("array",(cache!=undefined||cache!=null)?cache+","+getRow:getRow);
newSheet.appendRow([PropertiesService.getUserProperties().getProperty("array")]); //Show add your row number
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment