# (Solved) Total number of rows in the airtable **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** solved, airtable\ **Created:** [March 1, 2020, 11:48pm UTC](https://community.thunkable.com/t/solved-total-number-of-rows-in-the-airtable/492841 "2020-03-01T23:48:42Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![jeyseny](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@jeyseny](https://community.thunkable.com/u/jeyseny)\ **Post date:** [March 1, 2020, 11:48pm UTC](https://community.thunkable.com/t/solved-total-number-of-rows-in-the-airtable/492841/1 "2020-03-01T23:48:42Z")
How to get total number of rows in the airtable? ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [March 2, 2020, 12:10am UTC](https://community.thunkable.com/t/solved-total-number-of-rows-in-the-airtable/492841/2 "2020-03-02T00:10:32Z")
![Screen Shot 2020-03-01 at 3.57.47 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/6/f6f879e3d42be5a52f77b3de58ee93d4f8e036f1.png) ---
**Author:** ![jeyseny](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@jeyseny](https://community.thunkable.com/u/jeyseny)\ **Post date:** [March 2, 2020, 1:46pm UTC](https://community.thunkable.com/t/solved-total-number-of-rows-in-the-airtable/492841/3 "2020-03-02T13:46:56Z")
Thank you! ---
**Author:** ![jeyseny](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@jeyseny](https://community.thunkable.com/u/jeyseny)\ **Post date:** [March 2, 2020, 6:40pm UTC](https://community.thunkable.com/t/solved-total-number-of-rows-in-the-airtable/492841/4 "2020-03-02T18:40:01Z")
I couldnt get to work this code. variable is blank. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/d/fd8793696841119c06bd13c930903d86b74fd3fb.png) ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [March 2, 2020, 6:49pm UTC](https://community.thunkable.com/t/solved-total-number-of-rows-in-the-airtable/492841/5 "2020-03-02T18:49:52Z")
Sorry you’re having a hard time with this @jeyseny, a few things to think about here. does the column name as you have it typed here, match EXACTLY what is in airtable Why limit this to 100 rows, if you have that many or more, it will always return only 100. I would suggest 10000 or something like that unless you need to limit it to the first 100 rows have you double checked your airtable URL and API key settings? ---
**Author:** ![jeyseny](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@jeyseny](https://community.thunkable.com/u/jeyseny)\ **Post date:** [March 2, 2020, 8:46pm UTC](https://community.thunkable.com/t/solved-total-number-of-rows-in-the-airtable/492841/6 "2020-03-02T20:46:54Z")
Yes, I have the exact column name. I am connected to airtable, because I am retrieving other data from the table. Not sure how the length works. because getcolumn will return the list. ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [March 2, 2020, 10:26pm UTC](https://community.thunkable.com/t/solved-total-number-of-rows-in-the-airtable/492841/7 "2020-03-02T22:26:00Z")
Does the error block return anything if you set a label’s text to error? ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [March 2, 2020, 10:55pm UTC](https://community.thunkable.com/t/solved-total-number-of-rows-in-the-airtable/492841/8 "2020-03-02T22:55:39Z")
Vital! I admittedly skip this step as regular practice but it’s important and helpful! ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [March 3, 2020, 7:22am UTC](https://community.thunkable.com/t/solved-total-number-of-rows-in-the-airtable/492841/9 "2020-03-03T07:22:48Z")
![изображение](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/3/737d5e7ab783232bacd6911bc12920f17193ff96.png) ---
**Author:** ![farhanlatif027i3df](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/farhanlatif027i3df/32/65615_2.png) [@farhanlatif027i3df](https://community.thunkable.com/u/farhanlatif027i3df)\ **Post date:** [March 3, 2020, 12:58pm UTC](https://community.thunkable.com/t/solved-total-number-of-rows-in-the-airtable/492841/10 "2020-03-03T12:58:52Z")
What I do is. I get a list viewer and a label From airtable block I get the column which will always be filled or you can make a new column and set text field to “auto number” and then set this column block from airtable block to list viewer then you set block. Set label to get length of list viewer get items ---
**Author:** ![thestrengthinstitute](https://avatars.discourse-cdn.com/v4/letter/t/48db29/32.png) [@thestrengthinstitute](https://community.thunkable.com/u/thestrengthinstitute)\ **Post date:** [June 27, 2020, 4:25pm UTC](https://community.thunkable.com/t/solved-total-number-of-rows-in-the-airtable/492841/11 "2020-06-27T16:25:15Z")
Hi, I have an Airtable where different columns have different lengths. ![1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/3/a38cbb8d8e1ba4f117c6867e6e10fa908d6d478e.png) When I count rows of column 7AM using the LENGTH function, it shows me TOTAL number of rows (8) instead of 3. Whats the way around this problem? ---
**Author:** ![simondelvecchio](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/simondelvecchio/32/80476_2.png) [@simondelvecchio](https://community.thunkable.com/u/simondelvecchio)\ **Post date:** [September 5, 2020, 11:20pm UTC](https://community.thunkable.com/t/solved-total-number-of-rows-in-the-airtable/492841/12 "2020-09-05T23:20:24Z")
Perfect! ---
**Author:** ![gobassky](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/gobassky/32/77019_2.png) [@gobassky](https://community.thunkable.com/u/gobassky)\ **Post date:** [September 6, 2020, 10:01am UTC](https://community.thunkable.com/t/solved-total-number-of-rows-in-the-airtable/492841/13 "2020-09-06T10:01:03Z")
> [@thestrengthinstitute](#): > > Hi, > > I have an Airtable where different columns have different lengths. > > ![1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/3/a38cbb8d8e1ba4f117c6867e6e10fa908d6d478e.png) > When I count rows of column 7AM using the LENGTH function, it shows me TOTAL number of rows (8) instead of 3. > Whats the way around this problem? You have to count “non-empty” cells if you want to count the names. In the airtable, as long as there is a data in any column it will count as a “record” which is read across. Hence all your columns have 8 records. ---
**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, 11:25am UTC](https://community.thunkable.com/t/solved-total-number-of-rows-in-the-airtable/492841/14 "2024-11-08T11:25:26Z")