Hello,
I am setting up an automation bot to email out a list of logs made for the day, so I set the event up as a scheduled event occurring at 11:59pm daily. Because it’s scheduled, it is not giving me an option anywhere to select a table.
In the task I set up the email template and, predictably, it says “Table: No Table” at the top. When I try to preview my email, I get an “Invalid Table” error message, even with a blank template.
Without finding any way to bring a table into the context for the event, I ended up turning “For each row in table” to ON and then setting the condition to “FALSE” so it would not trigger off of any rows.
That was still enough to carry the table over to the process which allowed me to preview & send my emails.
Is this a known problem, and does anyone know of better workarounds than this?
You may want to mention for which records in the table you would like to send emails. For example are the emails based on a row specific data for each receiver? Each row may have an email address and you may wanting to send the updated data for that row to that email address. In such a case “For Each Row in the table” would be a valid option. For example, you wish to send emails to only those rows where the record was updated during that day.
So the row filter can be something like DATE([Updated_At] )= TODAY()
If you have some other logic, then please mention your requirement in more detail so that a most appropriate approach could be suggested.
Ah, that’s a good point. I had put all of that logic into the email template.
It’s pulling all the emails from a Staff table and all the logs from a DailyCallLogs slice. In the event I had it act on the slice, but it certainly makes sense to act on each email from Staff.
Thanks!