Re: Medicine Reminder system
I finished the scenario. I will attach screenshots below and hopefully it will be self explanatory. You will have to create a filter for each day of the week in Artable and depending on the day of the week you will select that day in your scenario. If you want to set up a schedule, to automatically sent out an email, let me know and I can help with that.
Screenshot #’s 1-4 are for module 1 and connection setup for the first two modules and how to trigger the scenario.
Screenshot #5 is module 2.
Screenshot #6 and #7 is module 3.
Mary
Pardon my interruption, but I’d like to propose a much simpler alternative. Integromat scenarios don’t have to only be triggered by a CREATED TIME or LAST MODIFIED TIME field. You can also run a scenario on a specific schedule, like once a day, once every hour, etc. In this case, it looks like you’ve already got the critical piece in place to make a daily email happen: you have a formula that uniquely identifies the specific record that contains the necessary medicine info for “today” (whatever day it is). You don’t need the created/modified fields at all, just a two-module scenario in Integromat, and the proper scheduling setup.
In Integromat, you start the scenario with an Airtable “Search Records” module:
This is a slightly truncated view of the module setup, but the pieces showing are all you need: your base, table, and the formula:
Note="Have today"
That will return the single record marked by the {Note} formula in Airtable. From there, you add the Email module as the second step, setting it up as you desire to pull whatever other field data you want to construct the email.
To get this to run daily, click the clock symbol on the Airtable module and set it up as follows:
Obviously set the Time field to a time that makes sense for you, but that’s it. You’re done! With this running every day, it will pick up the marked record from Airtable and send the details via email.
