javascript - Prevent input from being edited in Google Sheets -

-

how prevent timstamp being edited user has editing permisions on sheet. have sheet inputs date , time in 1 column after column edited, know if posible permit other users see date in column b when edit column after date set make no 1 can edit or erase it, column entry time recorded.

thanks in advance.

ps: using code

function onedit(event)  {    var timezone = "gmt-04:00";   var timezone2 = "gmt-04:00";   var timezone3 = "gmt-04:00";   var timestamp_format = "mm-dd-yyyy hh:mm:ss"; // timestamp 12hour format   var timestamp_format2 =  "mm-dd-yyyy hh:mm:ss"; // timestamp 12hour format   var timestamp_format3 =  "mm-dd-yyyy hh:mm:ss"; // timestamp 12hour format   var updatecolname = "cantidad"; var timestampcolname = "solicitado"   var updatecolname2 = "cantidad ordenado"; var timestampcolname2 = "fecha ordenado"   var updatecolname3 = "cantidad entregada"; var timestampcolname3 = "fecha de entrega"   var sheet = event.source.getactivesheet(); //name of sheet want run script.      var actrng = event.source.getactiverange();    var editcolumn = actrng.getcolumn();    var index = actrng.getrowindex();    var headers = sheet.getrange(1, 1, 1, sheet.getlastcolumn()).getvalues();    var datecol = headers[0].indexof(timestampcolname);    var updatecol = headers[0].indexof(updatecolname); updatecol = updatecol+1;    if (datecol > -1 && index > 1 && editcolumn == updatecol) { // timestamp if 'last updated' header exists, not in header row itself!     var cell = sheet.getrange(index, datecol + 1);     var date = utilities.formatdate(new date(), timezone, timestamp_format);     cell.setvalue(date);    }


Comments

Post a Comment

Popular posts from this blog

html - Styling progress bar with inline style -

-
i trying set progress bar color red using inline style. need in way because have access <body> part of document. style need apply: progress { color: red } progress::-moz-progress-bar { background: red;} progress::-webkit-progress-value { background: red; } progress[aria-valuenow]:before { background: red; } i tried <progress style="background: red;"> incorrect effect, progress bar color turns blue red background. guide right direction desired style? thank in advance. here live example: https://jsfiddle.net/z36d3f6l/
Read more

java - Oracle Sql developer error: could not install some modules -

-
i have downloaded fresh copy of sqldeveloper ( sqldeveloper-4.1.3.20.78-no-jre ) oracle website. when unzip , lauch gui, keep getting following error message: warning - not install modules: dynamic module config - no module providing capability org.netbeans.netbinox found. my system: windows 7 32 bit hp probook. jdk 1.6 , 1.7, 1.8 available in java/jdk subdirectory. netbeans 8.0.2 installed finally got way out after dirty hours. extracted sqldeveloper zip in nested directory. i.e: e://a/b/c/sqldeveloper. starting sqldeveloper gui above directory threw erros. solution: go in c:\users**username**\appdata\roaming : delete sql developer , sqldeveloper folders extract sql developer zip in new non nested directory. i.e: e:// start , should work now reference: https://community.oracle.com/thread/3870680?start=0&tstart=0
Read more

How to use autoclose brackets in Jupyter notebook? -

-
this may sound silly question, how make use of autoclose brackets in jupyter notebook? example, when type print( jupyter notebook auto-closes brakets print() and places cursor inside. type argument, say print(1 + 1) now cursor between second 1 , right bracket ) . key navigate right of ) ? of course can press end or → or ) achieve this, not seem save time, purpose of brackets autoclose suppose? thanks in advance.
Read more