Send SMS reminder if form not submitted

535 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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.