Counting a Db with specific row IDs?

Questions about Thunkable
1

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 :slight_smile:

2

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.

1 Like
3

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

1 Like