I have not asked questions for a long time, but the following task has appeared and I ask for help from the community.
- There is a TABLE 1 (with a parent entry);
- There is TABLE 2 (with child records);
- 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);
- 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.
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.