# AirTable to filter (search) table

**URL:** <https://forum.xojo.com/t/airtable-to-filter-search-table/37794>\
**Category:** General\
**Created:** [May 23, 2017, 8:13pm UTC](https://forum.xojo.com/t/airtable-to-filter-search-table/37794 "2017-05-23T20:13:07Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ryan\_Hartz](https://forum.xojo.com/user_avatar/forum.xojo.com/ryan_hartz/32/630_2.png) [@Ryan\_Hartz](https://forum.xojo.com/u/Ryan_Hartz)\
**Post date:** [May 23, 2017, 8:13pm UTC](https://forum.xojo.com/t/airtable-to-filter-search-table/37794/1 "2017-05-23T20:13:07Z")

</div>

Hi. I just signed up for AT today and am going by the example project, but this only shows a method to update to the table. I figured out how to add and delete from the table through a Xojo app, but now I am trying to figure out how to search the records.

I see you use the GET statement as in the example project to GetAllArtists, but I’m not sure how to pass in a search criteria to find any/all matching records. Is anyone familiar with how to do this?

---

<div class="post-metadata">

**Author:** ![Paul\_Lefebvre](https://forum.xojo.com/user_avatar/forum.xojo.com/paul_lefebvre/32/3152_2.png) [@Paul\_Lefebvre](https://forum.xojo.com/u/Paul_Lefebvre)\
**Post date:** [May 23, 2017, 8:22pm UTC](https://forum.xojo.com/t/airtable-to-filter-search-table/37794/2 "2017-05-23T20:22:20Z")

</div>

The AirTable webinar might have some additional info to help:

[http://developer.xojo.com/webinar-airtable](http://developer.xojo.com/webinar-airtable)

---

<div class="post-metadata">

**Author:** ![Ryan\_Hartz](https://forum.xojo.com/user_avatar/forum.xojo.com/ryan_hartz/32/630_2.png) [@Ryan\_Hartz](https://forum.xojo.com/u/Ryan_Hartz)\
**Post date:** [May 23, 2017, 8:35pm UTC](https://forum.xojo.com/t/airtable-to-filter-search-table/37794/3 "2017-05-23T20:35:46Z")

</div>

Thanks Paul. I did watch the video but didn’t see anything about searching records.

I’ve got the grasp of searching records using sqlite as

```auto
dim sql as String = "SELECT * FROM table WHERE field LIKE '%" + txtSearch.Text + "%'"
```

But am not sure how to accomplish this with AT.

---

<div class="post-metadata">

**Author:** ![Paul\_Lefebvre](https://forum.xojo.com/user_avatar/forum.xojo.com/paul_lefebvre/32/3152_2.png) [@Paul\_Lefebvre](https://forum.xojo.com/u/Paul_Lefebvre)\
**Post date:** [May 23, 2017, 8:43pm UTC](https://forum.xojo.com/t/airtable-to-filter-search-table/37794/4 "2017-05-23T20:43:56Z")

</div>

I thought Tim had covered filtering in the video, but he did do a blog post with some examples using “filterByFormula”:

[http://timdietrich.me/blog/airtable-api-filter-records-and-fields/](http://timdietrich.me/blog/airtable-api-filter-records-and-fields/)

---

<div class="post-metadata">

**Author:** ![Ryan\_Hartz](https://forum.xojo.com/user_avatar/forum.xojo.com/ryan_hartz/32/630_2.png) [@Ryan\_Hartz](https://forum.xojo.com/u/Ryan_Hartz)\
**Post date:** [May 23, 2017, 8:54pm UTC](https://forum.xojo.com/t/airtable-to-filter-search-table/37794/5 "2017-05-23T20:54:46Z")

</div>

Oh wonderful Paul! I was hoping for something like this. You guys rock, and I appreciate the webinar videos!

---

<div class="post-metadata">

**Author:** ![system](https://forum.xojo.com/uploads/default/original/1X/455b4dcc0e61630e9f81940004ddffa49c432a46.png) [@system](https://forum.xojo.com/u/system)\
**Post date:** [October 29, 2020, 6:46pm UTC](https://forum.xojo.com/t/airtable-to-filter-search-table/37794/6 "2020-10-29T18:46:54Z")

</div>