I’ve been playing around with Airtable for the past month. I think it’s possible to do what I want, but I’m not sure without upgrading to the Pro plan, and even then I’m not certain of the details. I wondered if anyone knows of a similar example I could follow.
Our club meets twice a month and members have requested SMS reminders of meetings. I have a table of members requesting SMS. I have a table of upcoming meetings.
I was thinking I could have a new table that would display just the next meeting when it is 5 days away (via filtering). So most times this view would be empty, then 5 days before a meeting, one record would appear, my trigger for block automation.
The new meeting record in the view would trigger the “Send SMS Block”, sending a reminder to each member in the “Members Requesting Reminders” table. And probably set a “done” value in the Meeting record so that it disappears from the Upcoming Meeting view so it cannot run again.
Wow that sounded simpler in my head before I typed it out. Thanks for any ideas you have.