I have a script that I am testing on a CRM system we use and I’ve run into an issue. The basic automation workflow looks like this:
A new record is added to a form which shows up in a view called “unprocessed.” This view is filtered on a linked record field, and any new record entered via a form will be missing the linked field data and so will automatically show up in this view.
As soon as the record drops into the view, the automation script fires
The trigger is “When a record enters into a view”
The action is to run a script.
The script itself loops through a second table to find matching records - and updates the appropriate linked records field for any matching records it finds. As a result, the record no longer appears in the unprocessed view since it now has a value in the linked record field.
The script runs well when there is one record in the view, but when multiple records enter the view at near the same time I believe it causes conflicts as the script runs for each record. The specific error message I’m seeing is:
Error: Exceeded quota of 15 mutations per second.
I’m thinking either the script needs to be optimized to run more quickly/smoothly, or I need to have the automation pause somehow before it processes each new record.
Given that I’m not sure what the mutations error means I’m not sure which direction to head.