[SOLVED 1/31/24 7:37 AM EDT] Using Airtable in my Apps

Questions about Thunkable X
1

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

2

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

3

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
    image1400Ă—750 29.4 KB

    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!!

4

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

5

WOW, is sounds good!
But I still need bases… In this block:

image
image1612Ă—336 52.8 KB

which data I have to set in URL and Authorization??

Grazie!!

6

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

At least it worked for me, but i suggest you to go through teh docs i sent you, everything it’s literally written there

7

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
image920Ă—356 34.1 KB

Running, the App goes in crash… Where is my error?

Grazie

8

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.

9

Ciao!

On Creating a record:

image
image1878Ă—1126 224 KB

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!

10

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
image1922Ă—966 112 KB

(updating bloks)

The “delete” function is ok!

Can you help me please?

Grazie

11

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

Hopefully it will help

12

Grazie Maurizio!
I missed the “Content-Type” component!

:hugs:

13

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
image844Ă—478 25.3 KB

then in the blocks I take a picture and I want to store it in the “atlFotoQui” field:

image
image1552Ă—624 79.8 KB

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

14

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