Reading data from Airtable

I am trying to make a simple login page with a table in airtable.
There are two fields userid and password.

When the user inputs his Id in the input box, i want to check if the userid is in the database. I cannot figure out how to do that.

Any help would be much appreciated.


If you want to do this as the user is typing, you’d have to pull all usernames into Composer and compare the input to those values, e.g. with the formula IS_IN_ARRAY or IS_IN_ARRAY_BY_KEY. Though that wouldn’t be very secure, as all usernames would be available to anyone trying to log into the app.

Another option would be to do that check when pressing log in, maybe the standard log in function in Airtable already does that check and sends it back as an error?