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

Popular posts from this blog

java - How to set log4j.defaultInitOverride property to false in jboss server 6 -

c - GStreamer 1.0 1.4.5 RTSP Example Server sends 503 Service unavailable -

Using ajax with sonata admin list view pagination -