Setting data action only creates new rows instead of updating existing rows

I have attempted to establish a bot that does this simple process.

  • Every day at 11 pm trigger a process to reset my "Status" column
  • The process should change column "Status" to value "Not Started"

Where I am at currently:

My bot runs successfully when I test it, but the process only adds new rows to the database instead of updating the existing rows in the "Status" column to be "Not Started"

Screen Shot 2022-10-14 at 12.23.44 PM.png

 

Here is my bot settings

Screen Shot 2022-10-14 at 12.26.06 PM.png

 

 

Here is the process that is triggered by the bot. The process is meant to update all values in column "Status" to "Not Started". Instead the process simply makes new blank rows with the single value.... ignores all of the "Completed" columns that need to be updated to "Not Started".

Screen Shot 2022-10-14 at 12.25.30 PM.png

 

The bot is in fact running successfully, but the process is not conducting what it seems to imply that it should.

Screen Shot 2022-10-14 at 12.24.16 PM.png

Solved Solved
0 6 257
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

AppSheet Database is in preview, meaning it is not ready for use in any important app.

View solution in original post

6 REPLIES 6
Top Labels in this Space