Automation: Atomicity and Locking
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.
Forum Discussion
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.
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.