Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

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 734
14 REPLIES 14
Top Labels in this Space