I want to create an alert that warns me if there are vehicles that have a technical test in the month. This vehicles have a field where this date is indicated. The date is in day/month/year format (dd/mm/yyyy).
Bot has this formula: " AND([DATA SCADENZA REVISIONE] <= EOMONTH(TODAY(), 0), [DATA SCADENZA REVISIONE] > EOMONTH(TODAY(), -1)) "
I have two technical tests to do in february, however the system only shows me 1 vehicle. Where am I doing wrong? The other problem is that the automatic email doesn’t start.
email text:**"**Messaggio automatico: attenzione , verificare la data di scadenza della revisione del veicolo <<[NOME VEICOLO]>> che è prevista per il giorno <<[DATA SCADENZA REVISIONE]>>. Grazie."
Where is it showing you anything if the email you expect isn’t sent?
Maybe there’s more to your template, but what you shared will only ever represent a single row. Potentially, what you’re missing is to define the list of rows the template should be applied to. See Use Start expressions in templates - AppSheet Help.
Where? Is this expression in the automation event’s Condition property? In the “Check if…” step in your screenshot? Regardless, confirm all the columns referenced in this expression exist in the VEICOLO table.
I don’t understand what you’re referencing.
A good troubleshooting technique for automations is to monitor bot execution using the Automation Monitor. The information there can show you the data included in each step and whether a step succeeded or failed.
