Help

Workaround for automations only selecting 100 records

Topic Labels: Automations
1392 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Rose_Haft1
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi there - 

We are setting up automation to find records that meet certain criteria -- either via a view or several 'Find Record' set-ups but the 'Find Records' is stopping at 100 records.  What is the best work around for this? 

Rose_Haft1_0-1679855857492.png

 

Thanks! 

2 Replies 2

What do you want to do with the records after you find them?

My automation helpers scripts includes a script that will return a list of all the records in a view, even if there are over 100 records in the view. You can then use the resulting list in a repeating group in the automation. If you want cell values for each record, you would use a "Find Records" action to find the individual record by matching the record ID with a formula field that exposes the record ID.

Matthew_Stewart
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, does anyone know how I would find all records (over 100) with a particular value, then add up the total for an automation email? I did buy the automation helper one but it has a limit of 100, so I need something to bypass that.