# Help with displaying airtable data that contains the words filtered with the search engine

**URL:** <https://community.thunkable.com/t/help-with-displaying-airtable-data-that-contains-the-words-filtered-with-the-search-engine/2786316>\
**Category:** Questions about Thunkable X\
**Tags:** beginner\
**Created:** [January 16, 2024, 7:39pm UTC](https://community.thunkable.com/t/help-with-displaying-airtable-data-that-contains-the-words-filtered-with-the-search-engine/2786316 "2024-01-16T19:39:27Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![jccarbonerog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jccarbonerog/32/168944_2.png) [@jccarbonerog](https://community.thunkable.com/u/jccarbonerog)\
**Post date:** [January 16, 2024, 7:39pm UTC](https://community.thunkable.com/t/help-with-displaying-airtable-data-that-contains-the-words-filtered-with-the-search-engine/2786316/1 "2024-01-16T19:39:28Z")

</div>

hello! I need the help of the community. I have a data table in airtable but I need to implement filtering and show only the records that contain in one of their fields what is typed in a search engine. I have been reading posts but I can’t understand how I should do it. If anyone can help me with this, I will be very grateful. I am using the new version of Thunkable thank you

---

<div class="post-metadata">

**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:** [January 18, 2024, 10:17pm UTC](https://community.thunkable.com/t/help-with-displaying-airtable-data-that-contains-the-words-filtered-with-the-search-engine/2786316/2 "2024-01-18T22:17:00Z")

</div>

Hello @jccarbonerog and welcome to the community 🎉  
To build this you will need to connect a Data Viewer List with a local table. Each time that you will open the screen, the old data will be deleted from the local table and the new data will be saved to the local table if the condition is true. You can see the example below.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/6/d6e0c068c66db137a7c50ddcfd363a75a2ea28c6.png)

---

<div class="post-metadata">

**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:** [January 19, 2024, 1:57am UTC](https://community.thunkable.com/t/help-with-displaying-airtable-data-that-contains-the-words-filtered-with-the-search-engine/2786316/3 "2024-01-19T01:57:41Z")

</div>

> [@jccarbonerog](#):
>
> have a data table in airtable but I need to implement filtering and show only the records that contain in one of their fields what is typed in a search engine. I have been reading posts but I

A) Unfortunately filtering data via blocks has been a long forgotten oversight. 2) you should use the api blocks and call your base directly. Then you can apply filters.

---

<div class="post-metadata">

**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\
**Post date:** [January 20, 2024, 2:22am UTC](https://community.thunkable.com/t/help-with-displaying-airtable-data-that-contains-the-words-filtered-with-the-search-engine/2786316/4 "2024-01-20T02:22:30Z")

</div>

Hi @ioannis

You have the link for your project? if we can view how it look like.

---

<div class="post-metadata">

**Author:** ![jccarbonerog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jccarbonerog/32/168944_2.png) [@jccarbonerog](https://community.thunkable.com/u/jccarbonerog)\
**Post date:** [January 20, 2024, 12:29pm UTC](https://community.thunkable.com/t/help-with-displaying-airtable-data-that-contains-the-words-filtered-with-the-search-engine/2786316/5 "2024-01-20T12:29:56Z")

</div>

Thanks for your response but I can’t get it to work.  
Would you have an example that shows the total number of variables and functions?  
Could you give me an example if I give you all the data and variables that I use and need?

Thanks for your time

---

<div class="post-metadata">

**Author:** ![jccarbonerog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jccarbonerog/32/168944_2.png) [@jccarbonerog](https://community.thunkable.com/u/jccarbonerog)\
**Post date:** [January 20, 2024, 12:46pm UTC](https://community.thunkable.com/t/help-with-displaying-airtable-data-that-contains-the-words-filtered-with-the-search-engine/2786316/6 "2024-01-20T12:46:13Z")

</div>

Can you give me a little more information or tell me where I can learn it?

---

<div class="post-metadata">

**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:** [January 20, 2024, 3:06pm UTC](https://community.thunkable.com/t/help-with-displaying-airtable-data-that-contains-the-words-filtered-with-the-search-engine/2786316/7 "2024-01-20T15:06:13Z")

</div>

> [@Add search and filter capabilities using Airtable's API in your app](https://community.thunkable.com/t/add-search-and-filter-capabilities-using-airtables-api-in-your-app/1893509):
>
> Project link: [Project Link](https://x.thunkable.com/projectPage/628cee0c7d44b1001299782c) Purpose/description: Pulling in all data from Airtable can be too much sometimes. pulling in only the data you need, and having it presorted can save you time and processing power in your app. This project filters by Age and Sex, then sorts the data by age ascending. See how data comes in unfiltered when you remove the query parameters! slight_smile Goes well with: Apps powered by airtable.

I previously posted about this topic here 👆

Imo, the biggest issue you may run into is the api rate limits of airtable. Perhaps not. All depends on how you plan to interact with your db from any give instance of the app and how many avg concurrent users you plan on having during peak times.

---

<div class="post-metadata">

**Author:** ![jccarbonerog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jccarbonerog/32/168944_2.png) [@jccarbonerog](https://community.thunkable.com/u/jccarbonerog)\
**Post date:** [January 20, 2024, 5:45pm UTC](https://community.thunkable.com/t/help-with-displaying-airtable-data-that-contains-the-words-filtered-with-the-search-engine/2786316/8 "2024-01-20T17:45:18Z")

</div>

But Airtable no longer works with Api, right? How should I do it?

---

<div class="post-metadata">

**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:** [January 20, 2024, 6:31pm UTC](https://community.thunkable.com/t/help-with-displaying-airtable-data-that-contains-the-words-filtered-with-the-search-engine/2786316/9 "2024-01-20T18:31:51Z")

</div>

No. Thunkable isn’t working magic behind the scenes here.

> **[Airtable | Everyone's app platform](https://airtable.com/developers/web/api/list-records)**
>
> Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free.

They’ve just made changes related to accessing the api which is my guess why Thunkables airtable blocks are caching data calls to the airtable backend

If you use the api calls, there’s be no caching and you can actually filter results before the data is returned to the client.

---

<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:** [April 19, 2024, 6:32pm UTC](https://community.thunkable.com/t/help-with-displaying-airtable-data-that-contains-the-words-filtered-with-the-search-engine/2786316/10 "2024-04-19T18:32:35Z")

</div>

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