Hi All, new here so I’m still trying to get used to Make.
So here’s my use case: I’m running a class for many students. I have a database of their email and phone numbers on Airtable.
What I want to set up is: I have a calendar on Google Calendar that shows the public holiday which means we won’t have a class during those days. I want to send a notification to their email and phone (as a message) at 12 PM the day before the public holiday.
All events are set-up as all-day event on my calendar already.
How can I set it up so the notification is sent 12 PM one day before the event.
How do we filter up the Airtable database? I assume it should be on the link after the Airtable module?
How to make sure that the email and text are sent to each filtered student. I want to send an individual email to all students. All emails will contain the same content.
Thank you in advance, and apologize for any formatting error.
With the current setup you’ll first have to get the scenario to run on a schedule. You can have it run every day at 12pm. This way the messages and emails will be sent out at 12pm.
To have it be only sent out on days before the holiday you can have the first module be a Search Events. Then have a filter that will only let it pass if there is a holiday the next day.
Now you can have it go to airtable and retrieve the student contact info. I do not believe you need an iterator for the next step since the search module will return a bundle for each student.
You can use the filter and map the desired parameters right after this module to only get students that are enrolled.
Finally you can map each of the students info on the twillio and email modules.
Thank you for your help! I understand about the setting it runs daily at 12 PM instead.
However, when I tried Search Event, it showed that it needed to be connected to a different module before it.
Also, one thing that I forgot to mention, I created another Calendar to host only holidays. So in another word, this Scenario should run for all events in this particular calendar.
How does it work for multiple email addresses? Does Make automatically send an email for each address separately? I’m not familiar with this.
Search event should work as a trigger and yes each email will be sent according to the record unless you have multiple emails for one student in a single field. Then you will need to have it choose either one or both emails i suppose.
I reccomend taking the beginner course from Make acedemy. It will help you further understand the functionality with Make.
I figured out how to change the trigger, my bad for yesterday.
However, I still can’t figure out how to set it up so it will check for upcoming events only. I set it up but it returns results from 2019 instead.
You can setup your first module and the filter like this. Basically it will run everyday at 12pm and check to see if there is a holiday the next day. Since the holidays on Google calendar starts at 00:00 hours the search module will pick it up. Then add a filter where the scenario will only continue if a holiday is found (total number of bundles > 1). Hope this helps!
