Automated email not sending

vnessgee · 07-22-2024 04:30 PM

Hi all,

I am new to AppSheet and am trying to have an automatic email sent when the Status column is changed to "Not Started". I have a tracker table in sheet 1 in Google Sheets, where column A is the Meeting Date (date format), column B is the task (text format), column C is the Lead dropdown (i.e., the name of the Lead person for the task), column D is the Support dropdown (i.e., the name of the Support person for the task), column E is the Status dropdown (i.e., the status of the task), column F and column G are the start and end dates of the task respectively, column H is the Deliverable column (file format), column I is the Email Address column (text format), and column J is the Notes column (text format). I have a formula in column I the Email Address column where when the Lead and/or Support name are selected from the dropdown menu their respective emails will autopopulate into the Email Address column, separated by commas. I want to send a weekly email (at 9am PST) reminder to the emails where the Status is Not Started. I have selected [Email Address] as the value for the To field but the emails don't seem to send. I'm wondering if it's because there is a formula in the Email Address column even though the emails do show. Any help with this would be greatly appreciated. Thank you!

WillowMobileSys

Some things to check first. Is the app deployed? If not, it is a prototype app and emails are only sent to the App Creator. Additionally, Scheduled automation are not active, so the "send a weekly email" process would not work. You can test this Scheduled automation by using the "Test" button but still, emails are only sent to the App Creator. The emails will have text included that indicate who the email WOULD have been sent to if the app was deployed.

If your app is deployed, then please show us the automation you are using to generate and send the emails. Something is not setup correctly.

@vnessgee wrote:

I'm wondering if it's because there is a formula in the Email Address column even though the emails do show

If even one of the emails addresses is not being constructed properly and therefore not a valid email address, this will halt the automation and no emails will send.

vnessgee

Hi @WillowMobileSys thanks so much for your reply. The app is deployed. I have included screenshots of the automation setup. Please let me know if you need any other information.

WillowMobileSys

First, to place into word the intention of the bot....

"Send emails on Mondays at 9am for each RDA row where the [Status] column reflects "Not Started". An email is to be generated to the email address in [Email Address} column."

Two things to look further at:

1) Are there actually RDA rows being downloaded into the app with the status value of "Not Started"? Any Security Filters must be considered.

2) Does the expression in the [Email Address] column create a valid email address? Please show the expression you are using.

I would suggest a test of removing the [Email Address] column and replacing it with your personal email address. Then tap the Test button on the bot and see if you get the emails in your inbox. If not, test again by removing the Filter condition. You should definitely get emails then. If not, there is something wrong with the emails going out and you may need to reach out to AppSheet support for assistance.