Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function loadForm() {
- var ss = SpreadsheetApp.openByUrl(url);
- var ws =ss.getSheetByName("Options");
- var list
- =ws.getRange(1,1,ws.getRange("A2").getDataRegion().
- getLastRow(),1).getValues
- ()
- var htmlListArray = list.map(function(r) {return '<option>' + r[0] +'
- </option>' ;}).
- join('');
- return render("page",{list: htmlListArray});
- }
- function loadAnalyse() {
- var ss = SpreadsheetApp.openByUrl(url);
- var ws =ss.getSheetByName("Options2");
- var list =
- ws.getRange(1,1,ws.getRange("A2").getDataRegion().
- getLastRow() ,1).getValues(
- )
- var htmlListArray = list.map(function(r) {return '<option>' + r[0] +
- '</option>' ; }).
- join('');
- return render("analyse",{list: htmlListArray});
- //views
- Route.path("form",loadForm);
- Route.path("table",loadTable);
- Route.path("analyse",loadAnalyse);
- loadForm = e.parameter
- loadTable = e.parameter.v
- loadAnalyse = e.parameter.a
- if(Route[e.parameters.v]) {
- return Route[e.parameters.v]();
- } else{
- return render ("home");
- }
- switch(e.parameters.v) {
- case v:
- return Route[e.parameters.v]();
- break;
- case a:
- return Route[e.parameters.a]();
- break;
- default:
- return render ("Page");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement