Portfolio Details
Automated QR Attendance & Analytics Engine
This project involved designing a low-code gate pass and attendance tracking system using Power Apps for the front-end application, Google Forms for entry collection, and Google Sheets as the central database. The platform logs QR scans instantly, triggers automated status updates, and feeds live operational dashboards.
This project involved designing a low-code gate pass and attendance tracking system using Power Apps for the front-end application, Google Forms for entry collection, and Google Sheets as the central database. The platform logs QR scans instantly, triggers automated status updates, and feeds live operational dashboards..
Eliminating manual sign-in bottlenecks and managing high-volume access requests smoothly, while keeping data infrastructure lightweight and cost-effective by leveraging Power Apps alongside Google Sheets instead of complex database servers.
A unified low-code architecture connecting Power Apps UI, Google Forms data collection, and Google Sheets, delivering instant check-in verification, automated clearance notifications, and real-time attendance reporting.
Key Features
- Instant QR Scanning
- Power Apps Frontend
- Google Forms Integration
- Google Sheets Database
- Automated Clearance Notifications
- Live Attendance Analytics