At the moment I’m stuck on trying to make a login system that validates the login info (email and password) and goes to page 2 if it is successful. Basically, how do I make it so that it reads the emails and passwords in the google sheet and goes to the next page if the inputs in the email & password text fields match? Thank you so much!
It is not safe. Anyone with a link to the Google Sheets table will see all the passwords.
- You need to connect your Google Sheet to this service https://sheetdb.io/ first.
- Then enable Basic Authentication:
Here is the working example: login_using_googlesheets.pma (19.4 KB)
Google Sheet table should have the following fields: email and password
Setup Httprequest 1 widget:
online password widget is connected with the password database cell
Thank you so much, got it working thanks to you! I appreciate this program so much, cheers.