Can someone explain the timing by which work requests in the AppSheet queue are processed for bots? We've been monitoring a complex bot and suspect status changes (FILE_SENT_P below) may be getting processed before create file tasks. Is this possible? Here is the current flow of the bot:
- On trigger, Wait 10 minutes
- Create csv file 1
- Create csv file 2
- Create csv file 3
- Send Email with 3 files attached
- Send pdf Email
- Create Activity Record 1 (add row from this table)
- Set the status field of bot table to FILE_SENT_P
- Set the status of child records 1 (execute on a set of rows) - set status field to FILE_SENT_P
- Set the status of child records 2 (execute on a set of rows) - set status field to FILE_SENT_P
- Set the status of child records 3 (execute on a set of rows) - set status field to FILE_SENT_P
- Set the status of child records 4 (execute on a set of rows) - set status field to FILE_SENT_P
- Create Activity Record 1 (add row from this table)
- Set the status field of bot table to FILE_SENT_P