javascript - google apps scripts check contact exist, then update from sheet -

-

not sure i've gone wrong. trying check if contact exists before creating it. once done, adding timestamp row.

var dateformat = utilities.formatdate(new date(), "gmt-2", "yyyy-mm-dd' 'hh:mm:ss"); var tkhcontacts = spreadsheetapp.openbyid('###').getsheetbyname('contacts');  function update(){ // -- update contacts -- runs on master spreadsheet tkh contacts emf (contact)   // importrefresh(); don't need   var range = tkhcontacts.getlastrow();   var updatecol = tkhlastupdatedcol();   var data = tkhcontacts.getrange(updatecol+"1:"+updatecol+range).getvalues();   for(var n=range;n>1;n--)   {       var lastupdate = tkhcontacts.getrange(updatecol+n).getvalue(); // last update col        var email = tkhcontacts.getrange("h"+n).getvalue();       var fname = tkhcontacts.getrange("c"+n).getvalue();       var lname = tkhcontacts.getrange("d"+n).getvalue();       var city = tkhcontacts.getrange("k"+n).getvalue().trim();       var street = tkhcontacts.getrange("j"+n).getvalue().trim();       var zip = tkhcontacts.getrange("l"+n).getvalue();       var phone = tkhcontacts.getrange("i"+n).getvalue();       var date = tkhcontacts.getrange("e"+n).getvalue();       var work = tkhcontacts.getrange("f"+n).getvalue();       var photo = tkhcontacts.getrange("g"+n).getvalue();       var site = tkhcontacts.getrange("o"+n).getvalue();       var find = tkhcontacts.getrange("m"+n).getvalue();       var referrer = tkhcontacts.getrange("n"+n).getvalue();       var tkhnotes = tkhcontacts.getrange("a"+n).getvalue();       var ip = tkhcontacts.getrange("p"+n).getvalue();       var email2 = tkhcontacts.getrange("q"+n).getvalue();       var phone2 = tkhcontacts.getrange("r"+n).getvalue();        if(lastupdate == 'pending') {         var contact = contactsapp.getcontactsbyname(fname + " " + lname);         if(contact){continue}         else{           var contact = contactsapp.createcontact(fname, lname, email);           var group = contactsapp.getcontactgroup('emf');           group.addcontact(contact);           var contacts = contactsapp.getcontactsbyname(fname + " " + lname); }      }     (var in contacts){contacts[i].setnotes(date + "\n\n" + work + photo + find + '\n' + referrer + '\n' + ip + '\n' + site + "\n\n" + tkhnotes);}     tkhcontacts.getrange(updatecol+n).setvalue(dateformat);   }

should straightforward i'm having difficulty.


Comments

Post a Comment

Popular posts from this blog

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more

python - Error while using APScheduler: 'NoneType' object has no attribute 'now' -

-
i have python app hosting on heroku. use apscheduler call function every day @ time. strange thing 1 time function runs after while have following error log: exception in thread apscheduler (most raised during interpreter shutdown): 2017-09-06t15:03:28.347848+00:00 app[web.1]: traceback (most recent call last): 2017-09-06t15:03:28.347858+00:00 app[web.1]: file "/app/.heroku/python/lib/python2.7/threading.py", line 810, in __bootstrap_inner 2017-09-06t15:03:28.347859+00:00 app[web.1]: file "/app/.heroku/python/lib/python2.7/threading.py", line 763, in run 2017-09-06t15:03:28.347861+00:00 app[web.1]: file "/app/.heroku/python/lib/python2.7/site-packages/apscheduler/schedulers/blocking.py", line 27, in _main_loop 2017-09-06t15:03:28.348167+00:00 app[web.1]: <type 'exceptions.attributeerror'>: 'nonetype' object has no attribute 'now' any guesses? the full code long here key parts: def startdayauto(): global ...
Read more