Get number of rows in one column in Airtable

[julesr]

Hi I am new to Thunkable, trying to get a Sign-Up/Log-In test app going. The app is connected to an Airtable database from which I need to retrieve username and password. Now I thought to structure it like this:
-User enters Username and password
-app loops through all usernames and stops once it finds the name, returns cell index.

Sounds easy enough but “call Airtables GetColumn” asks for the max number of rows already, which will change since it’s a database that keeps being added to. I can’t figure out how to just get the number of rows in one column, any help? thanks a lot!

[Balanced_Kitchen]

Option 1

use this block instead of 20
Option 2

[muneer]

Try this sample app

https://x.thunkable.com/projectPage/600af1322199cd001294c042

[julesr]

Thanks a lot! A question though:
Option 2: This returns an object of all rows but now I am in the same situation as before, I have to get the number of all entries in that object, but GetAllRows returns me a list like [0,1,2,(etc until last entry)]

[julesr]

Thanks a bunch This taught me a lot

[muneer]

@julesr

but GetAllRows returns me a list like

When you get the list of rows, you can use the length in the List drawer to get the number of rows.

[Balanced_Kitchen]

used in combination with a block “length of”