Automation: Atomicity and Locking

  • 0
  • 2
  • Question
  • Updated 8 months ago
  • Answered
Do Automations run as an atomic transaction and/or perform any row/table locking while they run?
Wondering if/how my application will behave when multiple users simulataneously run Automations.
Photo of Test Account

Test Account

  • 220 Points 100 badge 2x thumb
  • Concerned

Posted 8 months ago

  • 0
  • 2
Photo of Alex Gale

Alex Gale

  • 1,428 Points 1k badge 2x thumb
I'm not sure what some of these terms mean, but I think I've asked a similar question to a developer during one of their live tutorial sessions.

They assured me that if users attempt to run the same automation simultaneously, the system will queue the automations up, and fully complete the first before moving onto the second.

Hope that answers your question.
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 11,768 Points 10k badge 2x thumb
Hi,

Working with Automations when they fire they queue up very much like multiple users attempting to do actions at the same time running through Quick Base. They run in order of when they are triggered and as such if four automations fire all close together, all editing the same field, the last Automation to fire will be the one reflected at the end in the changed record but each automation will have run in order till the last one resolves. I hope that information is helpful. 
So, Evan, are you saying all the 4 will run one AFTER the other, in the order they were queued? In other words, will the second one wait until the first one finishes or will it run simultaneously?
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 11,768 Points 10k badge 2x thumb
They will run one after the other if they are going into the same destination application just like user actions would queue working in an application. Quick Base handles those requests as they come in, but some Automations might trigger off of multiple record changes as an Import from CSV call which would run as a single job. This is in the case of an Automation that triggers off of mass edits taking place all at one like Grid Edit or Import. If instead those four actions were triggered by four different users then they would process like any user action in order. It depends on how they are triggered.