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?
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.
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.