LinkedIn
Twitter
I am fairly new to using the automation section in Appsheet, and I have implemented a Bot to automate a daily "Carry-Over Summary" email. I have it set as a "scheduled event" to send the email every evening at 8:00 PM. The body of the email consists of a Google doc template I have created that is supposed to list any orders on my [Orders] table that has a [Status] = "carryover". A preview of the template is screenshot below.
ERROR #1 - The first error I am encountering is the number of emails that is being sent. I need for there to be only one email sent when the "scheduled event" takes place at 8:00 PM. Currently, whatever the number of orders on my [Orders] table that have a [Status] = "carryover" is the number of emails being sent. So for example, if 4 orders have a [Status] = "carryover", the app is sending 4 emails.
ERROR #2 - The second error that's occurring is that my template is not producing the data for the list that it is supposed to. Below is a screenshot of the email I am getting, there should be 3 orders listed that match the filter in place, instead it is blank.
Any recommendations or insight into what I may be doing wrong would be greatly appreciated. Thanks so much
