How to get all the row from Airtable

[Girish_Siva]

I am trying to get all the data from Airtable at a time and work with that. Is that possible?

[dora_paz (Dora)]

It is possible , see here how how you can get data from Airtable using the GetAllRows block

Error Using Airtable's component Get All Rows

That kind of error is obtained when you try to get data from a Json and the logic you use to extract the data does not match with the structure of the json Here is an example of how you can get data from Airtable using the GetAllRows block (with this block you get a Json in the response content) using dictionaries Note: In airtable it is easier to get each column and then work with those data as lists This is my Airtable structure: [imagen] We create the variables for each airtable column.…

[Girish_Siva]

Hi,
I am trying to get all the data and find the percentage accordingly, Please find the attachments below,

For the above image I should filter Repair and PM separately

I should all the labour(i.e. 5+5+5+5=20)

I should all the Travel(i.e. 1+1+1+1=4)

Need to count number of rows with 0-2 value only

Need to count number of rows with 0-2 value only

Need to count number of rows with 0 value only

And all the above values should be displayed.

Is this possible?

[dora_paz (Dora)]

Everything is possible but you have to try it yourself . I prefer to work with columns and I use when got column instead of get all rows. See also this approach in the post below. Once you receive your data in lists you have to work with them according to your needs

How to Get data from Airtable and put it into a CardView

Is there any way to use Asynchronous image loader with that extension? I tried it with Image Utilities without any success

[Girish_Siva]

But in the post they are not filtering, they are only getting the data and sorting.

[dora_paz (Dora)]

There are a lot of posts on how to filter data, use Try something first and post your blocks to get more help

https://community.kodular.io/search?q=filter%20airtable%20order:latest