Help

Send SMS reminder if form not submitted

510 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Yossi_Goldblatt
5 - Automation Enthusiast
5 - Automation Enthusiast

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.