how does a bot works ? Concurrently or queued fashion ?

[jaichith]

Hi, 

I am in the process of testing a workaround for sequential keys/ Serial number for mulituser application .  I want to know  how the bot works when 3 or more users initiates a bots at the same time . ( Bot a triggered in an add event of a table). 

Note : It is single bot , which is triggered by each user. which has the same functionalities. in image I have described as Bot 1,2,3 it is just of understanding purpose which user has initiated it. 

Does it act concurrently ?

Or lined up in a queue and acts one by one ?

workarounds which I am working are given below

Post 1 

Post 2

Post 3

[Trevwiller]

https://support.google.com/appsheet/answer/11828262?hl=en&sjid=12364656496394047703-NC

When multiple bots are triggered simultaneously in AppSheet, they generally run concurrently, but within each bot, tasks are executed sequentially. This means that while one bot's tasks are processed one after another, multiple bots can be running their sequences of tasks at the same time. Here's a detailed breakdown:

1. Concurrent Bot Execution: When multiple bots are triggered at the same time, they can start executing their tasks concurrently. This allows for parallel processing of different workflows.

2. Sequential Task Execution Within Each Bot: Within each individual bot, the tasks are executed sequentially. The bot will complete one task before moving on to the next one in its defined sequence.

3. Resource Management: The actual concurrency level might depend on the available system resources and the specific configurations of the AppSheet environment. If there are resource constraints, the system might throttle or queue some bot executions to ensure stable performance.

Overall, AppSheet's design allows for efficient handling of multiple workflows by running bots concurrently while maintaining a sequential order of tasks within each bot.

[jaichith]

You have said tasks are done sequential fashion. I have another doubt. 

How when same bot is triggered 2 or more times.? 

Does the bot trigger 1 and trigger 2  works in queued fashion or concurrently. 

[Trevwiller]

When two users activate the same bot on separate rows in AppSheet, the bot processes these triggers sequentially rather than concurrently. Each trigger is handled one after the other, ensuring data consistency and avoiding conflicts.

However, the actions performed by the bot on different rows are isolated to those specific rows. This means that while the triggers are handled sequentially, the operations on separate rows do not interfere with each other. This isolation can give the appearance of concurrent processing, but technically, the actions are still queued and processed one at a time.

[jaichith]

So for example,

task/process of  trigger 2 is executed when task/process of trigger 1 is completed. 

Is my understanding right ?

[Trevwiller]

correct

[jaichith]

You say that it is a sequential process. I too created the same kind of workflow in the bot.
If the triggers and processes are sequential then I should not get pending status..... Due to the condition which I have used.
(Please check the bot for the wait conditions). But I got pending status. Then it denotes bots are not sequential.

I think trigger 1 processes and trigger 2 processes are acting simultaneously .

Please check and update me

App name : TEST-6502531
Bot name: copy - when new entries are created in test table

Even I have posted a problem in community and appsheet support too for reason for pending status. Please see the below link

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Malfunction-Wait-in-bot/td-p/773993

If you need, I can share the app for testing.