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,
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?
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 Try something first and post your blocks to get more help
https://community.kodular.io/search?q=filter%20airtable%20order:latest