Bot create file (pdf) creates countless (27) files, all the same, instead of one

[stefanasks]

I made a bot on Table_Clients on change column [is_active] from true to false, in order to get a backup document before client deletion. All straight forward with only default values given from AppSheet like auto generated template, file store and so on.

Table_Client has some related Tables but they were all empty.

So I triggered the bot by changing the [is_active] column from true to false and wonder why this action takes so long. A look into my google drive showed me the reason. AppSheet created 27 files, all the same, only the timestamp in the filename differs.

Maybe there were only 27 files due to a timeout stopped the script, because the last file had 0 bytes and was therefore malformed. A previous try on the same table created only 23 files.

So what can cause this, what did I wrong?

[WillowMobileSys]

All “data change” type automations operate on the premise of a SINGLE changed row. If you are changing a column on each client row and your Bot is configured to trigger on Client row changes, then you will be triggering that Bot for each Client row that was changed.

As another possibility, if you have a series of actions that are making several changes to the SAME row and your Bot triggers on data changes but has no specific criteria as to WHEN the bot is triggered, then EACH edit made by an action will count as a trigger to the Bot as well.

I hope this helps!

[stefanasks]

Found the reason. Its a bug caused by an empty label of an bot action, where the file options are defined. I could even reproduce it. See screenshots.

[Steve]

Wow! Good find!