Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Workaround for automations only selecting 100 records

Topic Labels: Automations
2047 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
kuovonne
18 - Pluto
18 - Pluto

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.