I’m trying to develop login app using spreadsheet as the login information. I managed to handle the login form process and successfully to do the screen changing (second screen called Screen_main).
Now I’m stuck to pass the login information the second screen. I’m not really sure what’s the reason. Actually, first time I hit the login button, it shows warning that the data (list length is 0). But when I try to hit it again it pass through the second screen (some times I have to hit the button more than 2 times).
I don’t know how to troubleshoot this since I don’t know how to log the output list (i.e. for google app script we can log the data).
You can save username and pass in tinydb and get data in another screen I am not saying to store whole data in tinydb just the user who is logged in just add his data to tinydb to pass to another screen and get data …
The Spreadsheet component has everything you need to obtain data and work with it. Why do you use the web component?
The error you get is because you get an empty list. Check that all airtable cells are full. If you have empty cells with Airtable you will not get any data.
Then with the spreadsheet component you get the columns that have the registration data. Then you compare that the data entered by the user is within the list obtained from each column. If they are, you open another window, if they are not you put a notification.
You could consider the idea of making a user system with Firebase. Their free plan allows you to do 10,000 verifications per month.
It is more secure and you do not manage user passwords. In firebase you can’t see their passwords. In Airtable instead you can see the password they have used to log in. Taking into consideration that people use more or less the same password, storing passwords without any kind of encryption is not safe for the person using your app…
Actually, it’s not about sending data between screen. I tried to figure out the data on the first screen,
listuser --> ok.
listAllData --> empty on the first button click, but if I hit for the second times, the data is there.