Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Increase Find Records Automation Limit to more than 100

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Matt_Grzan
5 - Automation Enthusiast
5 - Automation Enthusiast
Status: New Ideas

There is a need to increase the Find Records limitation of 100 records that either come from a specified view or matched conditions. With up to 250K records per base in 2023, finding only 100 records is very limiting. Increasing the Find Records limit to match the Repeating Groups Automation limit of 8000 items per input list would make a dramatic improvement.

2 Comments
ScottWorld
18 - Pluto
18 - Pluto

Totally agree with you that this is a big problem & significant limitation in Airtable. The restriction should be completely lifted to put Airtable in line with all other database apps that have no such limit.

The limit is based on Airtableโ€™s API limits which requires pagination for more than 100 records, but Airtableโ€™s Automations should be smart enough to know how to paginate through groups of 100 records without any further intervention from the user.

In the meantime, for those Airtable users who are reading this thread and are trying to find a workaround to this limit, there are 2 workarounds to this issue:

1. High-code: You can write your own JavaScript scripts to work around this limit.

2. No-code: Use an advanced Airtable automation tool like Make, which doesnโ€™t require any programming code at all, and automatically allows you to find as many records as you want in Airtable. You can literally type in โ€œfind up to 250,000 recordsโ€ (or any other number that you want).

There can be a bit of a learning curve with Make, so Iโ€™ve assembled a bunch of training resources in this thread: https://air.tableforums.com/t/make-com-basic-navigation-tips/277

0xab
5 - Automation Enthusiast
5 - Automation Enthusiast

+1

The feature is basically useless in Enterprise Scale, except one has a 1:1 relation.