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
没有评论:
发表评论