Bot error message difficult to understand

[Gerard_Chevalie]

I cannot seem to correct an error in a bot…
Here is what it is supposed to do :

1. My app is some kind of an inventory manager app.
2. 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 days after the reservation’s date, and another one [Statut_réserve], initially set to “En cours”
3. I want the bot to modify the [Statut_réserve] data from “En cours” to “Echue” when [Date_fin_de_reserve] is inferior to TODAY(). This means that the reservation is no more valid.
4. Here are the screenshots of the bot’s configuration.
   
   
   
   
   
   
   
   
5. Here is the error message I get when I test the bot. It is difficult to understand because there is a value in the field ‘Date_fin_de_reserve’…
   
   
6. Thanks in advance for your help !
   Gérard

[WillowMobileSys]

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.

[Gerard_Chevalie]

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

[Gerard_Chevalie]

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

[WillowMobileSys]

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 type specified. I sometimes set types for readability and have never experienced issues in any automation because of it. The data type of the column in AppSheet is what the automation’s use. Dates are finicky especially with locale settings but I still don’t think you should have experienced the issue you have.

[1minManager]

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 one it found.

The easy fix is to make it not required. But if it has to be required, then either change its required_if formula or include updating the [Reserve] in this action.

Simon@1minManager.com

[Gerard_Chevalie]

OK, thanks for the suggestion !
Gérard