I have a bot that runs daily to check if there are pending schedule changes to employee tasks.
I have a table of tasks and a child table of pending schedule changes to the tasks.
Today, my team scheduled 151 schedule changes and the bot never triggered. I can’t find any failure reason in the monitoring. From my research, I believe this is due to the internal limitation of the AppSheet automation and it being over the 5 minute run time.
If I manually limit the row number in the filter condition from the table, it will run.
If I try to use Top() formula in the filter condition it does not run.
LIST(Todays Schedule Changes[Key])
I can’t find any diagnostic information for why this isn’t running.
My thought was to take the Top 10 rows from a slice and schedule the bot to run every 20 minutes for a few hours.
I am approaching this problem in the best way?