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:
- user enter username , password
- the user authenticated
- 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
Post a Comment