How to "catch" data from new rows in the child Table, which was not there before the start of the Bot?

Hello everyone!
I have not asked questions for a long time, but the following task has appeared and I ask for help from the community.

Input data:

  1. There is a TABLE 1 (with a parent entry);
  2. There is TABLE 2 (with child records);
  3. There is BOT 1, which starts from the state (EVENT) of the parent record in TABLE 1. This BOT 1 creates several records in the child TABLE 2 using the Webhook call (Add row);
  4. There is BOT 2, which is triggered by a manual action, changing the state (EVENT) of the parent record in TABLE 1, but only after creating records in the child TABLE 2. BOT 2 creates an email with PDF attachment based on the data in TABLE 1 and TABLE 2.

A task:
How to put all this sequence of actions inside BOT 1?
How to configure the PROCESS in BOT 1 so that it waits for the creation of child records, and then generates an email with an attachment?

Results of my attempts:
All my attempts led either to letters with PDF attachments, inside which there was not enough data from the child records TABLE 2, or using the โ€œWait for a Conditionโ€ step, letters with the necessary data from TABLE 2 were received, but this is again an action from the user side.

0 14 703
14 REPLIES 14
Top Labels in this Space