AppSheet Automation - Schedule BOT with forEachRow option being enabled - is currently with a bug

I have reported to the support desk, hopefully the AppSheet devs team working on it, but let me share what we found.

If we set up a BOT with Scheduled event, ForEachRow option enable, and with step of “Branch on a condition”, it is not working by design, i.e. new bug. If your app has this set up, please be careful, your app may have been broken.

When the BOT is run, BOT is evaluate the condition based on 1st row (min _RowNumber) and do the following step based on True/False result of condition. On the first row, BOT does the job as expected. However, Bot will use this state for the rest of the reminder rows. Regardless of the context of the row, BOT will update the rest of rows in the same way as the first row. Serious bug.

3 Likes

I presented a sample & simple app to repro the issues and help support desk to understand easily.

This sample app has a BOT with : -

At the end, this BOT does completely wrong jobs. BOT just does the same jobs (regardless of the records context) on all the records,based of the first record on the top.

I tested with free and enterprise account, but the result was the same.

Everyone here in this community must be careful.

@devingu

2 Likes

If your apps do have such type of BOT, then ready to correct your own data manually, as it is possible that the BOT is creating completely wrong data, and run Task as you wish, even NOW.

1 Like

Hey Koichi, we are currently investigating this already. Will keep you posted! Whenever this is fixed, we will communicate back through the ticket you just submitted.

Thanks @devingu for your help.

1 Like

We will roll out a fix next Monday!

4 Likes

@devingu Thank you for the update!

I wait for a release of fix in due course. Have a great weekend.

2 Likes

We tested quickly now and it appears a fixed was rolled out as scheduled. I can confirm the observed bug is now gone.

@devingu

@takuya_miyai

3 Likes