Bot not triggering itself

[GillesB]

Hi everyone, I've got an issue with a bot that should trigger whenever a row is added on a table, but it doesn't trigger when this row is added from itself.
This is a problem because it prevents me from performing a loop.

In detail, I've got a bot that create a first row in "Participation" table when a row is added in "Activité" table (by the user). I include values for a counter ("Personnel count") and its max allowed value ("Total Personnel count" which is the size of the "Personnel" table), because I want to create rows in "Participation" for each row that exists in "Personnel", in relation to the new "Activité" row.

This bot works well, then I created a bot that should create new rows in "Participation" table, if a row is created in this table and its "Personnel count" is inferior to its "Total Personnel count". This one triggers well when "New activity" bot creates a row, but not when itself finishes creating a row.

So I tried to duplicate the "New Participation" bot but then it also duplicates the new rows and stop functionning after 5 iterations :

Then I deleted the "New participation" duplicate, and unchecked the "Wait for execution to complete?" property on my only "New participation" bot. Now it triggers itself one time, but no more (and I see no errors in the monitor logs).

Is there another way to do what I want?
I found that a "For Each Row In Table" functionnality exists in Scheduled events but I need it in an App event...

Thanks in  advance!

[TeeSee1]

You need to set this option on to make a bot trigger other bots

[GillesB]

Ha thanks a lot!
"New Activity" now triggers "New Participation", but "New Participation" doesn't trigger itself, I'll update my question.

[Suvrutt_Gurjar · Accepted solution]

---

@GillesB wrote:

Is there another way to do what I want?

---

In general it sounds that your are trying to add multiple rows to a table. You may want to check multiple tips on the topic for any hints. 

Search - Google Cloud Community

[GillesB]

Great, I found exactly what I needed here, thanks a lot!

https://www.googlecloudcommunity.com/gc/Tips-Tricks/FAQ-add-a-set-of-rows/m-p/258033

[Suvrutt_Gurjar]

You are welcome.

[whlim]

"bot that should trigger whenever a row is added on a table, but it doesn't trigger when this row is added from itself" <- i might be crazy but you can try selecting both add and update for the event, not sure if that helps.

[GillesB]

No, didn't changed the behavior.