Google Apps Script. Make script work in active row -
Google Apps Script. Make script work in active row -
i utilize simple table register tasks should clients. every time when reached task, send in history cell info adding date. need automate process , have script:
function goal (){ var ss = spreadsheetapp.getactivesheet(); var formatteddate = utilities.formatdate(new date(),"gmt+5", "dd.mm.yy..hh:mm"); var num1 = ss.getrange("b7").getvalue(); var num2 = ss.getrange("c7").getvalue(); var num3 = ss.getrange("d7").getvalue(); ss.getrange("d7").setvalue(num3+" / "+num1+" "+num2); ss.getrange("b7").clear(); ss.getrange("c7").setvalue(formatteddate); var range = ss.getrange("b7"); ss.setactiverange(range); }
a7 - name of client
b7 - active task
c7 - date of creating task
d7 - history of tasks
and here question:
now script work in 1 row range, how can create work in active row range?
function goal (){ var ss = spreadsheetapp.getactivesheet(); var formatteddate = utilities.formatdate(new date(),"gmt+5", "dd.mm.yy..hh:mm"); var row = ss.getactivecell().getrow(); var r = ss.getrange(row, 2, 1, 3); var rvalues = r.getvalues(); r.setvalues([["", formatteddate, rvalues[0][2] +" / "+rvalues[0][0]+" "+rvalues[0][1]]]); ss.setactiverange(ss.getrange(row, 2)); }
google-apps-script google-spreadsheet
Comments
Post a Comment