I have an event table, I need to send an email to hosts of the event one day before the event starts with the event details and the list of attendees(This data I have in a separate table).
Is it possible to achieve this scenario?
Currently I am trying to do this via backend workflows, I am not able to figure out a way to filter the events table, get hosts and then send mail to those hosts.
Have a look at SendGrid, you can use dates in your database of the event - days(1) and have the email sent automatically. You do need a paid plan though
In the backend workflow, schedule an API workflow list to filter and email.
On the Schedule Date, get the Event Date, + Days - 1.
Hopefully that works for your use-case.
This topic was automatically closed after 70 days. New replies are no longer allowed.
