Google Script var get undefined value

Question

I am having some problem with my code for Google Script below:

When I do: var Emails = e.parameter.Email; (IN FUNCTION Aut_User)

I cant get the value, it appears undefined, value is not passing from one function to another.

What is wrong?

function doGet() {
  var app = UiApp.createApplication();
  var grid = app.createGrid(3, 2);
  grid.setWidget(0, 0, app.createLabel('Informações para Login:'));

  var Contactemail = app.createTextBox();
  Contactemail.setName('Email'); 
  grid.setWidget(1, 0, app.createLabel('Email:'));
  grid.setWidget(1, 1, Contactemail);

  var Contactpassword = app.createPasswordTextBox();
  Contactemail.setName('Password'); 
  grid.setWidget(2, 0, app.createLabel('Senha:'));
  grid.setWidget(2, 1, Contactpassword);


  var panel = app.createVerticalPanel();
  panel.add(grid);


  var button = app.createButton('Logar');
  var handler = app.createServerHandler('Aut_User'); 
  handler.addCallbackElement(grid);
  button.addClickHandler(handler);

  panel.add(button);
  app.add(panel);
  return app;
}

function getColIndexByNamelink(colName, ID) {
  var sheet = SpreadsheetApp.openById(ID).getSheets()[0];
  var numColumns = sheet.getLastColumn();
  var row = sheet.getRange(1, 1, 1, numColumns).getValues();
  for (i in row[0]) {
    var name = row[0][i];
    if (name == colName) {
      return parseInt(i) + 1;
    }
  }
  return -1;
}

function Aut_User(e) {
  var ID = "0AqmZV_vU4x5cdFQyOFo2TlE3dkxFYi1rVUk3OUxzYWc";
  var sheet = SpreadsheetApp.openById(ID).getSheets()[0];
  var lastRow = sheet.getLastRow();
  var Emails = e.parameter.Email;  //PROBLEM HERE
  //parametros da outra funcao
  for (var i = 2; i < (lastRow + 1); i++) {
    sheet.getRange("A4").setValue(Emails);
    //conferir os dados
  }
}

Weehooey · Accepted Answer · 2012-08-20 14:24:40Z

1

You have a mistake in your code:

var Contactpassword = app.createPasswordTextBox();
Contactemail.setName('Password');

The second line here should be:

Contactpassword.setName('Password');

I found this by using the following code in Aut_User(e):

var app = UiApp.getActiveApplication();
var output = '';
for (var i in e.parameter) {
   output += i + ' = ' + e.parameter[i] + '; ';
}

Then sending 'output' to a place I could read it. I saw the value for 'Password' was the email address entered.

answered Aug 20, 2012 at 14:24

Weehooey

1,0081 gold badge10 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Serge insas Over a year ago

there is indeed a double name assignation and, quite logically, the last one has priority ;-) +1 for Weehooey's method, straightforward and efficient !

Renan Otero Over a year ago

Thank you, I have a question: how do I show a link on the screen is that this script runs as a gadget?

Weehooey Over a year ago

@RenanOtero I do not understand your question. You might want to start another question and ask with more detail.

Serge insas Over a year ago

Are you looking for the anchor widget?

Collectives™ on Stack Overflow

Google Script var get undefined value

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related