Hello!
We have an app which is used in production to create some laboratory quotes, data is saved in the Appsheet Database; till today, if users made some mistakes, I was able to solve them.
But now, there is a bot error message in Automation Monitor "Error encountered in step with name [Reset]: Error: Unable to find the specified row from AppSheet database Error: 'Set Column Values' Data action ''Set Column Values' Data action 'ResetareDevize'' failed with exception Unable to find the specified row from AppSheet database ."
The flow in a few words is this: user fill in a template table 1 using a Table View, data are copied to Table 2, then Table 1 is reset to 0, I mean all data filled in by user are put on 0, then a column from Table 2 is also reset to 0, I use this column as help to identify new data added in Table 2. The bot has a few steps, sending email with attachement, create a file on a drive, and last 2 are reset to 0 some fields in Table 1, then in Table 2.
I checked the logs, I saw that the automation worked step by step, sending email - Ok, create file - OK, reset Table 1 - ok, then there is a line "Edit row", which means user began to use again Table 1, and then final step of the bot, reset field from Table 2, which has an error. Even if there were errors, user didn't stop, and he created many quotes and finally he asked for help, because the quotes weren't correct anymore, they showed on the pdf a bunch of lines from previous quotes.
In order to solve the problem, I created a new bot, identical to the previous robot, I tested and the new quote was clear, the pdf contains the good rows, but the field from Table 2 is not reset to 0 - the last step from the automation has the same error. The field is reset to 0 using an action, "set the values of some columns". As a remark, I manually tested this action and it works, the field is reset to 0.
I don't know anymore where to find the problem and how to solve it.
Could you help me? It is a little bit urgent to make the app work again.
Thank you!
Regards!
Ruxandra
LinkedIn
Twitter
