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.
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).
