How to make bot triggered by another bot?

Hello,

Unfortunately, I can’t find an answer to the important questions about automation:

  • How can I start the process for a list of related rows?
  • How can I make an event trigger after the action of another bot?

Here is an example:

There are three tables:

Persons:

| person_key | archived |

Accounts:

| account_key | person | archived |, where [person] is a ref to Persons table,

Operations:

| operation_key | account | archived |, where [account] is a ref to Accounts.

When I set “[archived] = true” for a row in Persons, I need to set “[archived] = true“ for all [Related accounts] and [Related Operations] of those accounts.

I’ve created two bots:

  1. Archivate person’s accounts:
  • Persons Event: [_THISROW_BEFORE].[archived] <> [_THISROW_AFTER].[archived]
  • Process: set [archived] = true for [Related accounts]
  1. Archivate account’s operations:
  • Accounts Event: [_THISROW_BEFORE].[archived] <> [_THISROW_AFTER].[archived]
  • Process: set [archived] = true for [Related operations]

When “Archivate person’s accounts” bot changes Accounts[archived], “Archivate account’s operations” bot doesn’t start automatically despite triggering its event.

If I add a call to “Archivate account’s operations” process into the first bot, I can’t provide [Related accounts] to lookup process input.