Hey,
I am trying to get data from google sheets just after login. my sheet is this way column A has user name column B has password and column C has a unique id which will be used in a different screen for Arduino use. I I just need help to get back the unique id for a specific username and password.
my google script code is :
function doGet(e) {
var message = "";
var ss = SpreadsheetApp.openById(e.parameter.sheetId);
var sh = ss.getSheetByName(e.parameter.gridName);
var rg = sh.getName() + "!" + sh.getDataRange().getA1Notation();
var sql = e.parameter.query;
var qry = '=query(' + rg + ',"' + sql + '",0)';
var ts = ss.insertSheet();
var setQuery = ts.getRange(1,1).setFormula(qry);
var getResult = ts.getDataRange().getValues();
ss.deleteSheet(ts);
if (getResult[0][0] == "#N/A") {
message = 'username not present';
} else {
if (getResult[0][1] != e.parameter.pwd) {
message = 'incorrect password';
} else {
message = 'signed in';
}
}
return ContentService.createTextOutput(message);
}
I am a newbie to google sheets