# Counting a Db with specific row IDs?

**URL:** <https://community.thunkable.com/t/counting-a-db-with-specific-row-ids/3300635>\
**Category:** Questions about Thunkable X\
**Created:** [October 25, 2024, 9:08pm UTC](https://community.thunkable.com/t/counting-a-db-with-specific-row-ids/3300635 "2024-10-25T21:08:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nuuzonessqnzvv](https://avatars.discourse-cdn.com/v4/letter/n/bbce88/32.png) [@nuuzonessqnzvv](https://community.thunkable.com/u/nuuzonessqnzvv)\
**Post date:** [October 25, 2024, 9:08pm UTC](https://community.thunkable.com/t/counting-a-db-with-specific-row-ids/3300635/1 "2024-10-25T21:08:57Z")

</div>

I’m confused, please help!

I am filtering a large Db to order 1st/2nd/3rd place under certain conditions. Using the count block I have determined the list of row IDs that fit into my sub-category, these row IDs are stored as a list. E.g. Rows 1,4,6,7,etc…

I now want to search/count through the large Db, only searching the rows in my list 1,4,6,7,etc… to collect details.

Does anyone have a simple answer for this. I feel like it shouldn’t be too hard but I’ve been staring at a screen for a while & gone blank.

Many thanks 🙂

---

<div class="post-metadata">

**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:** [October 25, 2024, 10:29pm UTC](https://community.thunkable.com/t/counting-a-db-with-specific-row-ids/3300635/2 "2024-10-25T22:29:01Z")

</div>

It’s probably easiest to do this using Airtable’s _filterByFormula_ command using its API. You can find examples here if you search the forums.

---

<div class="post-metadata">

**Author:** ![nuuzonessqnzvv](https://avatars.discourse-cdn.com/v4/letter/n/bbce88/32.png) [@nuuzonessqnzvv](https://community.thunkable.com/u/nuuzonessqnzvv)\
**Post date:** [October 26, 2024, 10:08am UTC](https://community.thunkable.com/t/counting-a-db-with-specific-row-ids/3300635/3 "2024-10-26T10:08:22Z")

</div>

Hi @tatiang

Appreciate the support. Instead of using the _filterByFormula_ I went with getting the 1st, 2nd & 3rd values from my list. If it meets certain criteria E.g. Name = Bob. Then a stored variable is set to true.

I’m trying to work locally to minimise load times by calling an Airtable API. Thank you

---

<div class="post-metadata">

**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:** [January 24, 2025, 10:08am UTC](https://community.thunkable.com/t/counting-a-db-with-specific-row-ids/3300635/4 "2025-01-24T10:08:34Z")

</div>

Closed on January 24, 2025, 10:08am UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
