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

ios - MKAnnotationView layer is not of expected type: MKLayer -

-
Image
so code works fine logger riddled message. there way rid of or suppress it? postannotation.swift class postannotation: mkpointannotation { //mark: properties let post: post //mark: initialization init(post: post) { self.post = post super.init() self.coordinate = cllocationcoordinate2d(latitude: post.latitude, longitude: post.longitude) self.title = post.title self.subtitle = post.timestring() } } adding annotation let annotation = postannotation(post: post) self.map.addannotation(annotation) func mapview func mapview(_ mapview: mkmapview, viewfor annotation: mkannotation) -> mkannotationview? { if annotation mkuserlocation { return nil } var annotationview = mapview.dequeuereusableannotationview(withidentifier: "pin") as? mkpinannotationview if annotationview == nil { annotationview = mkpinannotationview(annotation: annotation, reuseidentifier: "pin")
Read more

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