Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onEdit(e) {
- var ss = e.range.getSheet().getParent();
- var sheet = e.range.getSheet();
- var row = e.range.getRow();
- var columns = [1, 2, 3, 4, 5, 6, 7, 8, 9];
- //assign titles as 'keys' to array
- var titles = []
- //assign values of edited row to array
- var values = []
- //create an object to associate the title to the new edited values
- var task = {}
- for(var i in columns){
- titles.push(sheet.getRange(1, noTouch[i]).getValue()); //push titles
- values.push(sheet.getRange(row, noTouch[i]).getValue()); //push values of updated row
- task[titles[i]] = values[i]; //add the values to their property names in task object
- }
- function GetInfo(row,column){
- for(var i in column){
- titles.push(sheet.getRange(1, noTouch[i]).getValue()); //push titles
- values.push(sheet.getRange(row, noTouch[i]).getValue()); //push values of updated row
- this.task[titles[i]] = values[i]; //add the values to their task
- }
- }
- var list = new GetInfo(row,columns);
- list.task["client"]
Add Comment
Please, Sign In to add comment