The title really says it all, but as an example, let's suppose person A and person B are currently using the same app.
If they were to both click a button to trigger a series of automations on the same table at the same time, would the series of automations for person B start only once the series of automations for person A are completed?
Yes, each automation instance runs atomically (one finishes before another starts). This means that at any one point in time, only one automation will run, so you will not see any race condition occur in Honeycode.
Hope that helps, and let us know if you have any other questions.