# How to read a single record on AirTable and maximum number of screens **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [October 18, 2022, 12:55pm UTC](https://community.thunkable.com/t/how-to-read-a-single-record-on-airtable-and-maximum-number-of-screens/2088212 "2022-10-18T12:55:45Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![biagio.prisco](https://avatars.discourse-cdn.com/v4/letter/b/73ab20/32.png) [@biagio.prisco](https://community.thunkable.com/u/biagio.prisco)\ **Post date:** [October 18, 2022, 12:55pm UTC](https://community.thunkable.com/t/how-to-read-a-single-record-on-airtable-and-maximum-number-of-screens/2088212/1 "2022-10-18T12:55:45Z")
Hello and greetings to all. I developed an app about the history of my city with app Inventor. To extend it to IOS I am considering using Thunkable. I have doubts and I hope you can help me. 1. In the app I use MySql through PHP scripts that are stored on my web space. I have brought all the tables in my database to Airtable and would like to try using it. I’m doing a test with Thunkable and I had no problem importing a list with all the records in a table. Instead I didn’t understand how to read a single record. Eg in the table the first field is ‘mokey’ and I would like to extract the record in which ‘mokey’ is equal to a certain value. I have made several tests but I have not succeeded. How can I do or where to read something to understand how what should be a simple reading? 2. Does the app on IOSs work well? without any problem? Thank you all for the help you will want to give me. ---
**Author:** ![biagio.prisco](https://avatars.discourse-cdn.com/v4/letter/b/73ab20/32.png) [@biagio.prisco](https://community.thunkable.com/u/biagio.prisco)\ **Post date:** [October 18, 2022, 8:22pm UTC](https://community.thunkable.com/t/how-to-read-a-single-record-on-airtable-and-maximum-number-of-screens/2088212/2 "2022-10-18T20:22:25Z")
I did some tests but I’m not happy with the results. It takes a few seconds to get the result (that’s only 500 records …). In the version developed with App Inventor (PHP + MySql) the result is very fast. Is there any other way to search for a record whose value of the first field I know? ![f1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/7/97b6c2656746693c1a42eb325bd332bb37f3b470.gif) ![f2](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/a/8a6fc7f3ee6653725e5cd10012984d6f96e07e2b.gif) ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [October 19, 2022, 3:20am UTC](https://community.thunkable.com/t/how-to-read-a-single-record-on-airtable-and-maximum-number-of-screens/2088212/3 "2022-10-19T03:20:38Z")
Use Airtable’s _filterByFormula_. It’s going to be **way** faster. See this: [The AirTable API (a more efficient way to integrate AirTable with Thunkable)](https://community.thunkable.com/t/the-airtable-api-a-more-efficient-way-to-integrate-airtable-with-thunkable/1021167) ---
**Author:** ![biagio.prisco](https://avatars.discourse-cdn.com/v4/letter/b/73ab20/32.png) [@biagio.prisco](https://community.thunkable.com/u/biagio.prisco)\ **Post date:** [October 19, 2022, 9:02am UTC](https://community.thunkable.com/t/how-to-read-a-single-record-on-airtable-and-maximum-number-of-screens/2088212/4 "2022-10-19T09:02:02Z")
Thank you! I’ll do a test today. ---
**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:** [October 19, 2022, 10:05am UTC](https://community.thunkable.com/t/how-to-read-a-single-record-on-airtable-and-maximum-number-of-screens/2088212/5 "2022-10-19T10:05:04Z")
The airtable api will always be faster to use. It’s a direct connection to airtable. When Using data blocks, data calls are proxies on a Thunkable server first; then sent to the client. The extra leg in the trip causes delays in getting/posting/editing data. Sure, they’re convenient but they also have drawbacks of use. ---
**Author:** ![biagio.prisco](https://avatars.discourse-cdn.com/v4/letter/b/73ab20/32.png) [@biagio.prisco](https://community.thunkable.com/u/biagio.prisco)\ **Post date:** [October 19, 2022, 12:51pm UTC](https://community.thunkable.com/t/how-to-read-a-single-record-on-airtable-and-maximum-number-of-screens/2088212/6 "2022-10-19T12:51:45Z")
Thank you! I did it. If I use multiple tables, should I create multiple AirTable API objects (one for each table) or set various URLs and parameters each time? ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [October 19, 2022, 2:31pm UTC](https://community.thunkable.com/t/how-to-read-a-single-record-on-airtable-and-maximum-number-of-screens/2088212/7 "2022-10-19T14:31:26Z")
I usually use a single API component and just change the settings as needed using blocks. ---
**Author:** ![biagio.prisco](https://avatars.discourse-cdn.com/v4/letter/b/73ab20/32.png) [@biagio.prisco](https://community.thunkable.com/u/biagio.prisco)\ **Post date:** [October 20, 2022, 3:12pm UTC](https://community.thunkable.com/t/how-to-read-a-single-record-on-airtable-and-maximum-number-of-screens/2088212/8 "2022-10-20T15:12:19Z")
Thank you ---
**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:** [January 18, 2023, 3:12pm UTC](https://community.thunkable.com/t/how-to-read-a-single-record-on-airtable-and-maximum-number-of-screens/2088212/9 "2023-01-18T15:12:34Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.