2021年4月28日星期三

how to set a globale variable in google script?

when i execute the program i receive variable (Fx_row: lign 6) undefined, i declare it in ligne 23, can u help me to resolve it , sorry for my english.

if (contents.callback_query) {     var id_callback = contents.callback_query.from.id;   var data = contents.callback_query.data;    if (data == 'Congés') {      var Congés = expenseSheet.getRange(2, 5).getValue();    sendText(Fx_row);    }    }     else if (contents.message) {  var id_message = contents.message.from.id;  var text = contents.message.text;  var firstName = contents.message.from.first_name;  var TextUpperCase = text.toUpperCase();    for (var i = 0; i <password.length ; i++) {     if (TextUpperCase == password[i][0]){    var Tosearch = TextUpperCase;  var TextFinder = expenseSheet.createTextFinder(Tosearch).findAll();  for (i = 0; i < TextFinder.length; i++) {  var F_row = TextFinder[i].getRow();  var Fx_row = F_row.toFixed(0);  }  }  }  
https://stackoverflow.com/questions/67309661/how-to-set-a-globale-variable-in-google-script April 29, 2021 at 08:48AM

没有评论:

发表评论