I cannot seem to correct an error in a bot… Here is what it is supposed to do : My app is some kind of an inventory manager app. A user may make a reservation for a product. These reservations are stored in a table named “Réserves” : it has a column named [Date_fin_de_reserve], for example 14…

Gerard_Chevalier: because there is a value in the field ‘Date_fin_de_reserve’… Is there something within the bot that is trying to clear the Date? I think the log is showing what the state of the row was at the time the bot was run.

I found the cause of the problem : in my Google Sheet, the format of the column ‘Date_fin_de_reserve’ was set to Date, I changed it to Automatic and the bot run without error… Not really intuitive but it works, so it’s fine… Thanks for your interest in my issue ! Gérard

Your updating one column. But you need to realise this action affects the entire row. It’s saying you have a column called [Reserve] which is required. But it’s blank in the row where the key column equals “b8d73e4c”. Note there maybe other columns as well where it’s blank - this is just the first o…

OK, thanks for the suggestion ! Gérard

Gerard_Chevalier: I found the cause of the problem : in my Google Sheet, the format of the column ‘Date_fin_de_reserve’ was set to Date, I changed it to Automatic and the bot run without error… Not really intuitive but it works, so it’s fine… Hmm, it shouldn’t really matter if the sheet has the …

Bot error message difficult to understand

AppSheet AppSheet Q&A

Gerard_Chevalie September 7, 2021, 7:25am 3

No, the bot is quite simple, I provided the screenshots of the different steps, it’s all there is…

Topic		Replies	Views
Bots don’t work AppSheet Q&A errors	8	20	August 23, 2021
bot Error AppSheet Q&A errors	12	41	April 17, 2024
Error In bot AppSheet Q&A automation , errors	0	7	December 27, 2023

Bot error message difficult to understand

AI Suggested topics