问题描述:

I am looking for help, I designed a screen with Apps Script GUI Builder GUIBuilder1.jpg see, and GUIBuilder2.jpg GUIBuilder3.jpg. I wrote a script see below. The script:

function doGet(e) {

var app = UiApp.createApplication().setTitle('Connection');

app.add(app.loadComponent("Identification"));

return app;

}

function valid(e) {

var app = UiApp.getActiveApplication();

BaseDonnéeEcrit = "0AhOtrpNkdxp1dExVS05FRUtmTG9JMHZKUFNQeHc1M0E";

NuméroSheetEcr = 0 ;

var dateinsc = new Date()

var lignecr = SpreadsheetApp.openById(BaseDonnéeEcrit).getSheets() [NuméroSheetEcr].getLastRow();

SpreadsheetApp.openById(BaseDonnéeEcrit).getSheets()[NuméroSheetEcr].getRange(lignecr+1,1,1,1).setValue(e.parameter.ident);

SpreadsheetApp.openById(BaseDonnéeEcrit).getSheets()[NuméroSheetEcr].getRange(lignecr+1,2,1,1).setValue(e.parameter.mdp);

SpreadsheetApp.openById(BaseDonnéeEcrit).getSheets()[NuméroSheetEcr].getRange(lignecr+1,3,1,1).setValue(dateinsc);

app.getElementById('AbsolutePanel2').setVisible(true);

app.getElementById('AbsolutePanel1').setVisible(false);

return app;

}

function fin(e) {

var app = UiApp.getActiveApplication();

app.getElementById('AbsolutePanel2').setVisible(false);

app.getElementById('AbsolutePanel3').setVisible(true);

return app;

}

I published the resource and executed, see EcranSaisie.jpg The sheet is not up to date, see Resultat.jpg. Please can you help me? thank you very much

相关阅读:
Top