Quick Base automation not working

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Acknowledged
Quick Base automation not working if records exceeded the count of 1000. 
Status :FAILED
 Message: Error: ActionExecutionException: Number of records returned exceeded max of 1000.
Photo of venkateswarlu

venkateswarlu

  • 20 Points

Posted 4 months ago

  • 0
  • 1
Photo of Matt Saforrian

Matt Saforrian, Quick Base Product Manager

  • 452 Points 250 badge 2x thumb
Hi Venkateswarlu,

It looks like you are trying to modify or delete more than 1,000 records in a single action. This is a limit that we have in place to prevent automations from going wild.

If that is your intention, I'm curious to hear about your use case and why you need to change so many records at once.

You can read more about our limits here in this help doc.

Best,

-Matt Saforrian
Product Manager, Automations
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,908 Points 50k badge 2x thumb
An alternate approach could be to set up a saved table to table import of the table into itself based on Record ID# matching itself and some field(s) with the new value being mapped into the target fields(s) to update.  Have the Automation run this import for qualifying records.

Then rather than Quick Base seeing this as 1000+ individual record edits it will see it as just 1 import which is super fast to run, even if there are way more than 1,000 records to be updated.