Some background: some time ago I posted a question about a bot returning errors of 3 different types. I resorted to a workaround but never really fixed error no.2 (read here https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Bot-returning-errors-of-3-different-types/m-p/4... )
Now, in that post, I was talking about an automation that was supposed to change the value of an existing row. So the error made sense (row was not found).
Now I am stuck with the same error even though the automation is supposed to perform an "add a new row" type of action. Why would the error be "row not found"?
Here's what I am getting:
Error encountered in step with name [Wait until [Data] is yesterday-Update_Input]: Could not update row with key:09/01/2022 23:12:30 from table:Registro presenze_Schema, row was not found.
Automation is built as following:
-event is of type data change, adds only, to a table named "Registro Presenze".
-Process is wait for a period of time (the period a duration calculated between timestamp and midnight - btw, thanks @dbaum )
- check if a certain condition exist, if it does, add a new row to the table "Registro Presenze"
now here's what I am not sure about: I thought I needed an action of type "add a new row to this table" but instead found "add a new row to another table using values from this row".
I used that one because it's the closest to what I need, and it still lets me choose which table to add to, so I chose "Registro Presenze".
Now the error I'm getting, as mentioned above, doesn't really make sense because it looks like the automation is trying to update an existing row instead of adding a new one.
Thanks for taking the time to read this, any help would be greatly appreciated.
LinkedIn
Twitter
