Skip to main content
Question

Quick Base automation not working

  • August 13, 2018
  • 0 replies
  • 21 views
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.
    This topic has been closed for replies.

    • MattSaforrian
    • Quickbase Staff
    • August 14, 2018
    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.
    Terms & ConditionsAccessibility statement