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”
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”.
@Koichi_Tsuji wow, looks like it was as simple as recreating the bot with the data source being a Google Sheet instead of an Appsheet Database. Recreated the data structure within a sheet and remade the bot with the same processes and actions pointing at the sheet-based tables and it worked instantly.
Long story short it looks like the solution is to just not use Appsheet database as of it’s current status… 14 Oct 2022. Hopefully this functionality will be fixed or some sort of solution will be posted on this thread. Maybe it’s some sort of setting within Appsheet database blocking this from working… hard to say.
