Bot writing and clearing data

[1minManager]

I have a bot that calls an API to fill in 4 seperate columns on saving or updating a row.  But its behavour is mind boggling.  Bascailly it runs, updates all the 4 columns, then clears any of the columns that were blank before.  There is nothing in the bot or anywhere else in the app telling it to do this.

So this started off as a project with @MultiTech to put some AI into a new App were developing for ourselves.  Every time you create and save a row it would use an Appsheet Bot and the AI API to populate those 4 columns. 

Then I noticed that when users just updated a row it would sometimes not write things into the AI columns.  So I created a second scheduled bot to find rows with just the first of the four columns blank.  This sort of worked except no matter how many rows there where it would only ever update the last blank row.  

Presuming this was some issue with the way the bot was grouping the changes.  I changed it so that the bot trigged off of an action.  The action would simply write "update" into a column then clear it.  To call that action I created a slice and a table view of all affected columns.  You could then tick each column and run the action and therefore the bot seperately on each.  But this made things stranger still.  Heres my best desription of what happens:

Before bot runs, trigger column its blank and some of the 4 AI columns have data in.  All have at least one column with no AI data

______ A _ C _
______ _ _ C _
______ A _ _ _

 Bot is triggered

Update A _ C _
______ _ _ C _
______ A _ _ _

Row 1 updated

Update A B C D
______ _ _ C _
______ A _ _ _

Row 2 updated

Update A B C D
Update A B C D
______ A _ _ _

Row 3 updated

Update A B C D
Update A B C D
Update A B C D

Update column is cleared on all rows at the same time.  All updated columns are reset to what they where before.

______ A _ C _
______ _ _ C _
______ A _ _ _

 For the sake of clarity, this bot is not affected by:

• Other bots - all other bots on this table are currently disabled
• Reset on edit - the app doesn't use any
• Action on Save - the app doesn't use any

Workng on a hunch I actually go it to not clear the AI data, though why this works also makes no sense.  As I said earlier the trigger bot sets a column to "Update" then clears it.  If I don't make it clear that column, and just leave it at "Update" then it seems to work ok.

Does anyone have any clue or idea why its working this way?