# Get number of rows in one column in Airtable **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [August 3, 2021, 2:54pm UTC](https://community.thunkable.com/t/get-number-of-rows-in-one-column-in-airtable/1428669 "2021-08-03T14:54:59Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![julesr](https://avatars.discourse-cdn.com/v4/letter/j/a8b319/32.png) [@julesr](https://community.thunkable.com/u/julesr)\ **Post date:** [August 3, 2021, 2:55pm UTC](https://community.thunkable.com/t/get-number-of-rows-in-one-column-in-airtable/1428669/1 "2021-08-03T14:55:00Z")
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! ![Screenshot (643)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/5/c5eb3e9b41d5a276a34dd7009b172141e5ced039.png) ---
**Author:** ![Balanced\_Kitchen](https://avatars.discourse-cdn.com/v4/letter/b/839c29/32.png) [@Balanced\_Kitchen](https://community.thunkable.com/u/Balanced_Kitchen)\ **Post date:** [August 3, 2021, 3:09pm UTC](https://community.thunkable.com/t/get-number-of-rows-in-one-column-in-airtable/1428669/2 "2021-08-03T15:09:53Z")
Option 1 ![1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/6/66766b17575386b4ea63a794db2ebb6f20e7a95d.jpeg) use this block instead of 20 Option 2 ![2](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/6/36cd0f0486050fe9a31110e5ab4d3c6693c53b25.jpeg) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [August 3, 2021, 4:46pm UTC](https://community.thunkable.com/t/get-number-of-rows-in-one-column-in-airtable/1428669/3 "2021-08-03T16:46:10Z")
Try this sample app [https://x.thunkable.com/projectPage/600af1322199cd001294c042](https://x.thunkable.com/projectPage/600af1322199cd001294c042) ---
**Author:** ![julesr](https://avatars.discourse-cdn.com/v4/letter/j/a8b319/32.png) [@julesr](https://community.thunkable.com/u/julesr)\ **Post date:** [August 4, 2021, 8:15am UTC](https://community.thunkable.com/t/get-number-of-rows-in-one-column-in-airtable/1428669/4 "2021-08-04T08:15:19Z")
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)] ---
**Author:** ![julesr](https://avatars.discourse-cdn.com/v4/letter/j/a8b319/32.png) [@julesr](https://community.thunkable.com/u/julesr)\ **Post date:** [August 4, 2021, 10:57am UTC](https://community.thunkable.com/t/get-number-of-rows-in-one-column-in-airtable/1428669/5 "2021-08-04T10:57:45Z")
Thanks a bunch This taught me a lot 🙂 ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [August 4, 2021, 11:26am UTC](https://community.thunkable.com/t/get-number-of-rows-in-one-column-in-airtable/1428669/6 "2021-08-04T11:26:45Z")
> [@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. ---
**Author:** ![Balanced\_Kitchen](https://avatars.discourse-cdn.com/v4/letter/b/839c29/32.png) [@Balanced\_Kitchen](https://community.thunkable.com/u/Balanced_Kitchen)\ **Post date:** [August 4, 2021, 1:56pm UTC](https://community.thunkable.com/t/get-number-of-rows-in-one-column-in-airtable/1428669/7 "2021-08-04T13:56:29Z")
used in combination with a block “length of” ![1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/6/56e652eee8fa1e57e55d8a3e71762ed6f77cf8e5.png) ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 1:17pm UTC](https://community.thunkable.com/t/get-number-of-rows-in-one-column-in-airtable/1428669/8 "2024-11-08T13:17:38Z")