I am unable to get these block work. I am trying to create a log in screen with google sheet. The problem is that the app only checks the user id. if the user id is correct and if the password is not empty it goes to the other screen. It would be nice if you could help me solve this issue.
The web app is providing appropriate responses when i checked .
function doGet(e) {
var ss = SpreadsheetApp.getActive();
var sheet = ss.getSheetByName("Log");
if (e.parameter.func == "login") {
var msg = "incorrectLogin";
var id= e.parameter.ids;
var pass= e.parameter.pass;
var loginData = sheet.getDataRange().getValues();
for (var i = 1; i < loginData.length; i++) {
if (ids== loginData[i][0] && pass== loginData[i][1]) {
msg = "loggedIn";
break;
}
}
return ContentService.createTextOutput(msg);
}
return ContentService.createTextOutput("Invalid function call");
}