How to open a link in the current window by pressing a button in Google App Script UIApp? -


i'm writing script allows user log in site. have done can't seem find way open new link after user has been authenticated pressing log in button.

steps:

  1. user enter username , password
  2. the user authenticated
  3. if user exists in spreadsheet link opened user's profile (this link can't seem working).

thank in advance help.

here working example : type 1 of names, if 3 letters correct link appears

function showdialog() {   var app = uiapp.createapplication();   app.settitle("anchortest");   var panel = app.createverticalpanel();   var txtbox = app.createtextbox().setname("tbox");   var subm = app.createanchor('ok', 'href').setid('subm').setvisible(false);   var fake = app.createbutton('enter lastname').setid('fake');   panel.add(txtbox).add(subm).add(fake);   var keyhandler = app.createserverhandler("textkey");   txtbox.addkeyuphandler(keyhandler);   keyhandler.addcallbackelement(panel);   var clickhandler = app.createserverhandler("showurl");   subm.addclickhandler(clickhandler)   clickhandler.addcallbackelement(panel);   app.add(panel);   var doc = spreadsheetapp.getactive();   doc.show(app); } // function textkey(e){   var app = uiapp.getactiveapplication();   var href = app.getelementbyid('subm');   var fake = app.getelementbyid('fake');   href.setvisible(false);   fake.setvisible(true);   var txtvalue = e.parameter.tbox;   var data=spreadsheetapp.getactivesheet().getdatarange().getvalues();     logger.log(data)     logger.log(txtvalue.length);     if (txtvalue.length>2){       for(nn=0;nn<data.length;++nn){         logger.log(txtvalue+'  '+data[nn][0])           if(data[nn][0].match(txtvalue)==txtvalue){           href.sethref(data[nn][1]).sethtml('accepted').setvisible(true);           fake.setvisible(false);           break;       }     }   } return app;   } //   function showurl(e){   var app = uiapp.getactiveapplication();   app.close();   return app;   } 

here data available in corresponding sheet (column & b)

> lastname  url > serge https://sites.google.com/site/appsscriptexperiments/home > john  https://sites.google.com/site/appsscriptexperiments/home/a-database-project > paul  https://sites.google.com/site/appsscriptexperiments/home/a-simple-search-tool-ui > mike  https://sites.google.com/site/appsscriptexperiments/home/doc-list-viewer 

Comments

Popular posts from this blog

java - Play! framework 2.0: How to display multiple image? -

gmail - Is there any documentation for read-only access to the Google Contacts API? -

php - Controller/JToolBar not working in Joomla 2.5 -