Discussions

Expand all | Collapse all

Quick Base automation not working

  • 1.  Quick Base automation not working

    Posted 08-13-2018 09:49
    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.  RE: Quick Base automation not working

    Posted 08-14-2018 13:08
    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


  • 3.  RE: Quick Base automation not working

    Posted 08-14-2018 13:38
    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.