# \[SOLVED 1/31/24 7:37 AM EDT\] Using Airtable in my Apps **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [January 26, 2024, 11:25am UTC](https://community.thunkable.com/t/solved-1-31-24-7-37-am-edt-using-airtable-in-my-apps/2804663 "2024-01-26T11:25:50Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![gm.cellinig8f](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/gm.cellinig8f/32/163435_2.png) [@gm.cellinig8f](https://community.thunkable.com/u/gm.cellinig8f)\ **Post date:** [January 26, 2024, 11:25am UTC](https://community.thunkable.com/t/solved-1-31-24-7-37-am-edt-using-airtable-in-my-apps/2804663/1 "2024-01-26T11:25:50Z")
Ciao. Is anybody so kind to help me find guides, tutorials and docs where I can learn how to use Airtable DB on my Apps? Grazie ---
**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:** [January 26, 2024, 3:26pm UTC](https://community.thunkable.com/t/solved-1-31-24-7-37-am-edt-using-airtable-in-my-apps/2804663/2 "2024-01-26T15:26:32Z")
If you’re starting out with Airtable, you might consider using the Airtable API and _filterByFormula_. It’s fast, powerful, and flexible. See this topic for my response and the working blocks: [filterByFormula via AirtableAPI](https://community.thunkable.com/t/filterbyformula-via-airtableapi/2226104) ---
**Author:** ![gm.cellinig8f](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/gm.cellinig8f/32/163435_2.png) [@gm.cellinig8f](https://community.thunkable.com/u/gm.cellinig8f)\ **Post date:** [January 27, 2024, 9:53am UTC](https://community.thunkable.com/t/solved-1-31-24-7-37-am-edt-using-airtable-in-my-apps/2804663/3 "2024-01-27T09:53:36Z")
Thankyou Tatiana, but there is still something I don’t understand: 1. I’m using OATH: which is the “WEB\_api URL”? 2. I have this simple table: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/a/cac3d78051aafed9eb22a736f176fa156df0325a.png) The query I’d like to get with block is: > Select \* > from Table > where atlCategoria=“B1” and atlDataAbbandono=0 Can you show me please a simple example in blocks? Grazie!! ---
**Author:** ![maurizio.polverini89](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/maurizio.polverini89/32/145191_2.png) [@maurizio.polverini89](https://community.thunkable.com/u/maurizio.polverini89)\ **Post date:** [January 27, 2024, 10:40am UTC](https://community.thunkable.com/t/solved-1-31-24-7-37-am-edt-using-airtable-in-my-apps/2804663/4 "2024-01-27T10:40:09Z")
To get all the access info, like the web URL, i found very useful these docs: Go to Airtable page, top right corner click on your personal image/account \> Developer Hub \> On the left, under “Resources” click on “Developer Docs” \> select “WEB API” from the 4 options \> Scrolla down and select your Base \> go to “Authentication” field Everything is written there, they teach you also how to do simple tasks Hope it helped ---
**Author:** ![gm.cellinig8f](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/gm.cellinig8f/32/163435_2.png) [@gm.cellinig8f](https://community.thunkable.com/u/gm.cellinig8f)\ **Post date:** [January 27, 2024, 2:08pm UTC](https://community.thunkable.com/t/solved-1-31-24-7-37-am-edt-using-airtable-in-my-apps/2804663/5 "2024-01-27T14:08:07Z")
WOW, is sounds good! But I still need bases… In this block: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/e/fe0272ab385967f97921b5ba777f1eb90b1c8c29.png) which data I have to set in URL and Authorization?? Grazie!! ---
**Author:** ![maurizio.polverini89](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/maurizio.polverini89/32/145191_2.png) [@maurizio.polverini89](https://community.thunkable.com/u/maurizio.polverini89)\ **Post date:** [January 27, 2024, 2:16pm UTC](https://community.thunkable.com/t/solved-1-31-24-7-37-am-edt-using-airtable-in-my-apps/2804663/6 "2024-01-27T14:16:08Z")
You can set the base directly in the URL. You can either write the Table ID or the table name ex. [api.airtable.com/v0/APP\_ID/TABLE\_ID](http://api.airtable.com/v0/APP_ID/TABLE_ID) At least it worked for me, but i suggest you to go through teh docs i sent you, everything it’s literally written there ---
**Author:** ![gm.cellinig8f](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/gm.cellinig8f/32/163435_2.png) [@gm.cellinig8f](https://community.thunkable.com/u/gm.cellinig8f)\ **Post date:** [January 27, 2024, 4:43pm UTC](https://community.thunkable.com/t/solved-1-31-24-7-37-am-edt-using-airtable-in-my-apps/2804663/7 "2024-01-27T16:43:13Z")
Maurizio! Your opened me a new world! Grazie!! Now I’m able to do the basics I need, but there still one thing I’m not able to: is it possible to set a query with more than a single “filterByFormula”? This is the case: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/c/4cdedc6f15c07933341c17197931aff160e3897b.png) Running, the App goes in crash… Where is my error? Grazie ---
**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:** [January 27, 2024, 7:30pm UTC](https://community.thunkable.com/t/solved-1-31-24-7-37-am-edt-using-airtable-in-my-apps/2804663/8 "2024-01-27T19:30:26Z")
You can use OR and AND statements inside of the filterByFormula property. You can see an example here: [The AirTable API (a more efficient way to integrate AirTable with Thunkable) - #22 by jared](https://community.thunkable.com/t/the-airtable-api-a-more-efficient-way-to-integrate-airtable-with-thunkable/1021167/22). ---
**Author:** ![gm.cellinig8f](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/gm.cellinig8f/32/163435_2.png) [@gm.cellinig8f](https://community.thunkable.com/u/gm.cellinig8f)\ **Post date:** [January 28, 2024, 3:39pm UTC](https://community.thunkable.com/t/solved-1-31-24-7-37-am-edt-using-airtable-in-my-apps/2804663/9 "2024-01-28T15:39:52Z")
Ciao! On Creating a record: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/5/55493a5d1e880ed9ea5ff925d92c3790b0082ed7.png) I get this error: {“error”:{“type”:“INVALID\_REQUEST\_MISSING\_FIELDS”,“message”:“Could not find field \“fields\” in the request body”}} Where is my error? Grazie! ---
**Author:** ![gm.cellinig8f](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/gm.cellinig8f/32/163435_2.png) [@gm.cellinig8f](https://community.thunkable.com/u/gm.cellinig8f)\ **Post date:** [January 31, 2024, 7:32am UTC](https://community.thunkable.com/t/solved-1-31-24-7-37-am-edt-using-airtable-in-my-apps/2804663/10 "2024-01-31T07:32:32Z")
Ciao. I understamd that my problem is to write on tables in Airtable. In effect, further than having problems with writing new records, I have also with updating ones, with the same error: > {“error”:{“type”:“INVALID\_REQUEST\_MISSING\_FIELDS”,“message”:“Could not find field \“fields\” in the request body”}} ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/2/82d254240fdd22a6bb022f020e2353b8408d8552.png) (updating bloks) The “delete” function is ok! Can you help me please? Grazie ---
**Author:** ![maurizio.polverini89](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/maurizio.polverini89/32/145191_2.png) [@maurizio.polverini89](https://community.thunkable.com/u/maurizio.polverini89)\ **Post date:** [January 31, 2024, 8:16am UTC](https://community.thunkable.com/t/solved-1-31-24-7-37-am-edt-using-airtable-in-my-apps/2804663/11 "2024-01-31T08:16:35Z")
Hi, i’m just having a very quick look, did you add the Web\_API Header with the component for the authorization and the “Content-type” ? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/e/8e5588c69b9c543f4b4bf08631827a869c7c4723.png) Hopefully it will help ---
**Author:** ![gm.cellinig8f](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/gm.cellinig8f/32/163435_2.png) [@gm.cellinig8f](https://community.thunkable.com/u/gm.cellinig8f)\ **Post date:** [January 31, 2024, 10:35am UTC](https://community.thunkable.com/t/solved-1-31-24-7-37-am-edt-using-airtable-in-my-apps/2804663/12 "2024-01-31T10:35:31Z")
Grazie Maurizio! I missed the “Content-Type” component! 🤗 ---
**Author:** ![gm.cellinig8f](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/gm.cellinig8f/32/163435_2.png) [@gm.cellinig8f](https://community.thunkable.com/u/gm.cellinig8f)\ **Post date:** [January 31, 2024, 10:53am UTC](https://community.thunkable.com/t/solved-1-31-24-7-37-am-edt-using-airtable-in-my-apps/2804663/13 "2024-01-31T10:53:13Z")
Well: the more I use Airtable the more I have questions… I creates an “attachment” field in a table where I wanted it to store pictures: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/8/a85ab03b3fc060098c258a6f2757f87d950f60bb.png) then in the blocks I take a picture and I want to store it in the “atlFotoQui” field: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/0/106ce9c556062f5da51be7fce93800b4ed237862.png) But when I try to write the record I get this error from Airtable: > {“error”:{“type”:“INVALID\_ATTACHMENT\_OBJECT”,“message”:“Invalid attachment for field atlFotoQui: parameters must be objects, not strings”}} Where is my error please? Grazie ---
**Author:** ![maurizio.polverini89](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/maurizio.polverini89/32/145191_2.png) [@maurizio.polverini89](https://community.thunkable.com/u/maurizio.polverini89)\ **Post date:** [January 31, 2024, 12:37pm UTC](https://community.thunkable.com/t/solved-1-31-24-7-37-am-edt-using-airtable-in-my-apps/2804663/14 "2024-01-31T12:37:10Z")
To make sure someone can help you properly, i suggest you to check the answer you found useful and solved your problem as “Solution” and open a new topic in the Community with a relevant title. It will help the community itself to provide you the help you need and involve more people based on the updated question ---
**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 30, 2024, 12:37pm UTC](https://community.thunkable.com/t/solved-1-31-24-7-37-am-edt-using-airtable-in-my-apps/2804663/15 "2024-04-30T12:37:21Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.