Parent alerts for absences and an attendance report

On a schedule the scenario finds absent students, emails their parents and updates a clear attendance report.

  • Parents learn of an absence the same day
  • All absentees covered at once
  • A clear report updates itself
  • Runs on schedule, hands-off
Set it up for yourselfScriptera

How it works

To get Spreadsheet File notifications in devino, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: Recurring Time Trigger
  2. Then: Student Attendance Data
  3. Then: Extract Attendance CSV
  4. Check: Date Filter
  5. Check: IF: Is Absent?
  6. If yes: Students Contacts
  7. Then: Extract Contacts CSV
  8. Check: Merge Absent + Contacts
  9. Then: Alert Logic Block
  10. Then: Generate Absence Email
  11. Then: Send Email
  12. Then: Build Dashboard and Report
  13. Then: Existing Report History
  14. Then: Extract History CSV
  15. Then: Combine History + Build Dashboard
  16. Then: Convert Data
  17. Then: Build Visual Report and Update Attendance File
  18. If no: No Absences Today

You can launch this Spreadsheet File + devino integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios