Regarding Automation failure due to number of records exceed max 1000 limit

Question

Hi Team,I have created an automation however it's getting failed with Action Execution Exception: Number of records returned exceeded max of 1000. Records which are getting updated are more than 1000 in count.. What needs to be done in such scenarios.

Thanks,Vijay------------------------------vijay singh------------------------------

MarkShnierYou · Answer

You can split this into multiple Automations or probably a better suggestion if your are editing records is to use a saved table to table import which runs extremely quickly and has no limit on the number of records. I don't know what the nature of the updates you are doing to know if that is an option for you, but you can import a table into itself merging on Record ID and update a data entry field from a formula field.

But if you want to keep using your same method, you can for example use the REM function on the Record ID to determine the remainder when say divided by 3. REM([Record ID#],3) will return either a 0, 1 or a 2.

So you can add that as a filter to the Automation and run 3 separate Automations and each would be 1/3rd of the data.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

Sign up

Login to the community