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?
Page 1 / 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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.