List filter on Airtable Limited to 100 records

I have a simple grocery list app, that does what it is intended to do…create a grocery list. My goal is, I have a products table in airtable with approx 250 items. I search for products…my search works well except that it appears to me that it can’t search on all 250 products, just the 100 from the first api call as per Airtable. I see that there is an offset to use on the next call and any other subsequent calls. Any Ideas on how to search for products on the whole table?



Some awesome instructions from people who have overcome this API (pagination) limitaion in this post → Airtable Pagination (100 Record limit) fix