School: Absence Alerts
Every school morning it reads the attendance sheet, sends each absent student's parent a short Arabic WhatsApp message, and marks the row so no one is messaged twice. It never records the reason for absence.
Steps in this flow
- School days 9:30
- Google Sheets: unalerted absences
- For each absent student
- Parent phone present?
- WhatsApp alert to the parent
- Google Sheets: mark as alerted