Workaround for automations only selecting 100 records

[Rose_Haft1]

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? 

Thanks! 

[kuovonne]

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]

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.