Projects chevron_right WhatsApp Attendance Control Platform

schedule WhatsApp Ops functions Google Apps Script dns NestJS + Prisma phone_iphone React + Capacitor

WhatsApp Attendance Control Platform

A full-stack platform for attendance operations over WhatsApp. It combines Apps Script automation, a secure NestJS + Prisma backend, and a React/Vite + Capacitor app for administration, auditability, and mobile alerts.

code View on GitHub arrow_back Back to Projects

Stack

WhatsApp Google Apps Script NestJS Prisma + SQLite React + Vite Capacitor iOS

photo_library

Product screenshots

Login screen of the WhatsApp attendance control system — Login screen with the product brand and direct access to the operational dashboard.

Main dashboard with daily KPIs and attendance pulse chart — Admin dashboard with daily KPIs and a pulse visualization for attendance activity.

Administrative reports screen with date and employee filters — Reports module used to query date ranges, filter employees, and generate consolidated outputs.

flag

Objective

Unify attendance operations from WhatsApp to the back office, with reliable capture, daily visibility, role-based security, and a mobile experience ready for supervision and follow-up.

account_tree

System architecture

attendance_api: Google Apps Script handles WhatsApp operational logic, reports, triggers, and backward compatibility for legacy automations.
attendance_backend: NestJS API provides JWT auth, RBAC, Prisma persistence, audit logs, and notification read-state endpoints.
Frontend: React + Vite + Capacitor delivers the mobile/web experience, notification center, and iOS synchronization flow.
Data layer: Google Sheets powers operational records while SQLite supports auth, audit, refresh tokens, and notification state.

bolt

Core capabilities

• Attendance and operational events initiated from WhatsApp-connected workflows.
• Daily reports and business rules on top of Google Sheets without breaking the legacy process.
• Secure authentication with JWT, rotating refresh tokens, and strict role-based access.
• Notification center with pending permissions, recent movements, and audit activity.
• iOS push notifications plus cross-device synchronization for read/unread notification state.

update

Recent improvements

• Backward-compatible Apps Script wrappers that self-heal outdated triggers.
• Better iPhone notification center with a sheet-style panel and grouped toasts.
• Read/unread persistence first in local state and now synchronized through the backend.
• Expanded notifications module for push token registration, internal push delivery, and shared read-state.

emoji_events

Operational impact

• Lower dependence on manual entry and better consistency in attendance records.
• Better visibility for operations leaders through auditability, alerts, and follow-up from a single app.
• A technical base that is extensible for more rules, more clients, and real multi-device sync.