# Total Number or Rows in Airtable using blocks **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [November 8, 2024, 7:45am UTC](https://community.thunkable.com/t/total-number-or-rows-in-airtable-using-blocks/3330423 "2024-11-08T07:45:25Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![maurizio.polverini89](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/maurizio.polverini89/32/145191_2.png) [@maurizio.polverini89](https://community.thunkable.com/u/maurizio.polverini89)\ **Post date:** [November 8, 2024, 7:45am UTC](https://community.thunkable.com/t/total-number-or-rows-in-airtable-using-blocks/3330423/1 "2024-11-08T07:45:25Z")
Hi there, hopr you are well. This is what i’m trying to achieve with Airtable: Everytime a new record is created in a table, the app checks if the total number of rows is 250, if it’s so, it deletes the oldest entry (the 250th row) I know it sounds easy, but here the tricky part: the tablename is a variable - and can’t be fixed, because it depends on a result of a qrcode scan. I’m aware about this block: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/1/512390e02516457dc1896b1daef5dbbf1853cfae.png) But here you can’t actually change the tablename once the block is set. I came up with this solution that actually works okay, but it uses too many API Calls as Airtable just gives you maximum 100 results per page - and as Airtable set a limit, i was wondering if there was an easier solution - as it takes a lot of time performing this action, especially if the table is 3000 rows long. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/8/a8f4877ca3b11c30e19e0c13221ba32eedcb44b4.png) Is there any easier way to do it? I mean, i’d need a block like this one ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/1/512390e02516457dc1896b1daef5dbbf1853cfae.png) But considering the tablename as variable? * * * Linked to this question, i’d love to know if there is a block performing this action: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/9/694650242ec3c5e605382e7f6db4c565a29d5154.png) As these “airtable1” blocks dont work anymore and, if i’m using API calls, i can just delete a row by its “id number” (something like “cb7dkaacis927ff0”) and not the actual row number, like for example the 250th of the table. What i’m trying to perform here is to get rid of the 250th row Sorry if it sounded tricky, but hope you have a smarter solution Thank you very much for your time ---
**Author:** ![maurizio.polverini89](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/maurizio.polverini89/32/145191_2.png) [@maurizio.polverini89](https://community.thunkable.com/u/maurizio.polverini89)\ **Post date:** [November 8, 2024, 2:09pm UTC](https://community.thunkable.com/t/total-number-or-rows-in-airtable-using-blocks/3330423/2 "2024-11-08T14:09:33Z")
My bad, sorry i forgot to attach the other part of the blocks i’m using now: Every API call it gets 100 values and one “offset” value which means i need to call an API again with this offset value to get the next 100 values and so on, resulting in too many API calls and endless seconds ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/0/4044a4e78a4635379f4005da659d8e699116ba4a.png) So, my questions are: - Is there an easier way to detect how many rows an Airtable’s table has, considering that the table is a variable? - Is there a way to delete “row number 250”, without knowing the id? Thank you very much for your help ---
**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:** [November 8, 2024, 3:10pm UTC](https://community.thunkable.com/t/total-number-or-rows-in-airtable-using-blocks/3330423/3 "2024-11-08T15:10:19Z")
> [@maurizio.polverini89](#): > > - Is there a way to delete “row number 250”, without knowing the id? That’s what the built-in “ID” column in the `list of values in` block is for: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/e/3e0d67c5952a95e12facc0bc359eb947816a49da.png) ---
**Author:** ![maurizio.polverini89](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/maurizio.polverini89/32/145191_2.png) [@maurizio.polverini89](https://community.thunkable.com/u/maurizio.polverini89)\ **Post date:** [November 8, 2024, 3:17pm UTC](https://community.thunkable.com/t/total-number-or-rows-in-airtable-using-blocks/3330423/4 "2024-11-08T15:17:03Z")
Hello tatiang, thank you for your time replying. I’m aware of that block, but as you can see in the block you can’t use the tablename as variable ![Screenshot 2024-11-08 161519](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/c/bc03cdf5c1439f6b826bcdfd65675d46d0c86a2c.png) I would need that “Table 1” is a variable ---
**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:** [November 8, 2024, 7:14pm UTC](https://community.thunkable.com/t/total-number-or-rows-in-airtable-using-blocks/3330423/5 "2024-11-08T19:14:08Z")
Yes, I wish we could use a variable there. ---
**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, 10:25pm UTC](https://community.thunkable.com/t/total-number-or-rows-in-airtable-using-blocks/3330423/6 "2024-11-08T22:25:05Z")
Hi @maurizio.polverini89 It is a great suggestion and will pass it on to the team. ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [February 6, 2025, 10:25pm UTC](https://community.thunkable.com/t/total-number-or-rows-in-airtable-using-blocks/3330423/7 "2025-02-06T22:25:38Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.