Currently, I am sending MMS/SMS to my students manually, and want to automate this process. Each student will have different assignments on different days. So, a student could be graduating today, and another just starting.
When a student starts we have two dates, today's date, and grad date. And the difference is the message they should be sent. I currently use excel with the first table having name, phone number and grad date. The second tab has all the messages for 1 year. So if they graduate tomorrow, they are at day 364 today. I use the offset to automatically fill in this data but it does not allow to send MMS messages.
I am open to using AWS functions, Azure functions or Twilio functions. It has to be serverless and have the ability to send SMS or MMS on any day through Twilio. The Twilio MMS messages are protected, so only authorized users will be able to view MMS.
Below is basically what I want to do. But I am not a developer, and need a simple solution that can integrate with Airtable, or Mongodb? Please let me know what you propose.
[login to view URL]