Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Send SMS reminder if form not submitted

237 1
Showing results for 
Search instead for 
Did you mean: 

I want to send an SMS reminder to staff to submit their lesson plans if they haven’t yet submitted it for that week. What formula can I use to look at the most recently submitted lesson plan for that teacher and if it was after a specific date then include/exclude from the sms reminder?

1 Reply 1

If you have two tables, one for teachers, and another for submitted lesson plans, you can get the latest date using a rollup field with the formula MAX(values). Then you can use another formula field to compare that date with some other date. Finally, filter on that last formula field.