Forum Discussion

VenkateswarluKa's avatar
VenkateswarluKa
Qrew Member
6 years ago

Quick Base automation not working

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.

2 Replies

  • 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
  • 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.