Just wondering if anyone can shed some light on the expected behaviour of a Bot that is based on a Schedule.
Here is the scenario:
Scheduled Bot runs once a month against a MASTER table ForEachRowInTable and is set to run a data action that creates new records in another table called REPORTS. This works and creates the new rows as expected. I have set the options for the bot to Trigger Other Bots.
A second data change Bot is configured to detect the new entries added to the REPORTS table from Bot 1 and create a bunch of child records in a third Table. This uses a Run a Data Action with a Grouped Actions action. This does not trigger after the scheduled Bot 1.
The Grouped Actions work as expected if run from a button.
If I change scheduled Bot 1 to a Data Change Bot, Bot 2 triggers for the record I change and behaves as expected.
So my question is, can scheduled bots be used the way I’m trying to use them. I could probably run the second bot as a scheduled bot later on the same day each month, but curious about my approach.
Any feedback or advice would be appreciated.