List View Gets data from airtable problem

rajeshtechnepal · August 16, 2019, 6:43am

I cant able to gets data from airtable more then 100 data with List View

How Can I solve it ?

Help

techcvr · August 16, 2019, 7:06am

show your blocks,

rajeshtechnepal · August 16, 2019, 7:24am

techcvr · August 16, 2019, 7:50am

so if i am right your problem is - if get start value returns value 100 or more then it won’t show the results.?

rajeshtechnepal · August 16, 2019, 8:14am

i have records more then 100 lists in airtable after picking of 100 lists its works but not working more then 100 lists

techcvr · August 16, 2019, 8:29am

dude… i dont understand your problem properly, explain in details with steps, so i can understand and give you solution if possible.

and you didnt post image of your full blocks. if you dont explain your problem in details then no one can help you, we dont have that much time to chat, so try to explain as more as possible.

ShaikhSajidAli · August 16, 2019, 8:30am

Airtavle have restrictions for one time querry is 100 rows and 9 columns

techcvr · August 16, 2019, 8:37am

yes, now i have tested it and its confirmed that records more than 100 don’t load.

wait, i will try something else. lets see if it works or not

ShaikhSajidAli · August 16, 2019, 1:45pm

you can do two querrys one by one and store in global variable as sum of 100 rows or just mixed it

OfficialDjJohn · August 16, 2019, 3:20pm

I’m not sure if the problem is from airtable side or blocks side but if you elaborate about what you exactly trying to do then we can somehow help you

techcvr · August 17, 2019, 5:20am

he wants to show 100+ data in a list view from airtable.

OfficialDjJohn · August 17, 2019, 5:34am

Did you try using columns method…
It was working for me… I’ve shown about 150 items from airtable

OfficialDjJohn · August 17, 2019, 5:35am

Try using get cell method because the get row method doesn’t return the value in order…

rajeshtechnepal · August 17, 2019, 5:54am

please mention me block screenshot how can i do it using column method.

kartiktambi · August 17, 2019, 6:20am

Hello there,
I think this should work with Get_Cell and Get_Column :

Steps :

Take 5 spreadsheet components, add the same base id & api key & table name in all 5 components. All 5 will call the same spreadsheet.
On the blocks, rename the Column name with your Respective Column names. Ex. : Spreadsheet2 has the name of “Column2” & Spreadsheet3 has the name of Column 3 & same for Spreadsheets 1, 4 & 5.
Done!

I think this should work… Or there must be a better way to do this…

Thanks!

OfficialDjJohn · August 17, 2019, 11:54am

Bit lengthy process… BTW an idea

system · September 16, 2019, 11:54am

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.