Skip to main content

Workaround for automations only selecting 100 records

  • March 26, 2023
  • 2 replies
  • 42 views

Forum|alt.badge.img+14

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! 

2 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • March 26, 2023

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.


Forum|alt.badge.img+3

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.