How to get all the row from Airtable

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

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

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

image
For the above image I should filter Repair and PM separately

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

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

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

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

image
Need to count number of rows with 0 value only


And all the above values should be displayed.

Is this possible?

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

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

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

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

1 Like