I’m looking at a potential workaround that I can implement now to deliver scheduled push notifications.
I believe with the advent of the API for collections this should now be possible via setting up an external cron-like process in a tool like Zapier or Integromat that periodically hits the API for a collection called “Reminders” with fields “DueDateTime, user, subject, message, status.” It basically queries that table for
SELECT * FROM Reminders WHERE DueDateTime < Now() AND Status NEQ "Sent"
Anytime it finds a reminder that’s overdue, it executes a custom action which sends the message to the user via whatever medium he/she has opted for and marks status as Sent.
Does that seem like a sensible approach? Just want to sanity check this before going down this rabbit hole in the event someone else has already solved this another way and packaged it up elegantly… TIA