AirTable to filter (search) table

General
1

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?

2

The AirTable webinar might have some additional info to help:

http://developer.xojo.com/webinar-airtable

3

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

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

But am not sure how to accomplish this with AT.

4

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/

5

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