BridgeFlow One Phone Scan. Smarter Library Event Intelligence.
A practical case study on using QR codes, smartphones, Google Workspace, and Apps Script to automate registration, check-in, attendance tracking, certificate support, and reporting for library events.
Why this project matters
Many library events still depend on manual attendance lists, repeated data entry, slow verification, and delayed reporting. BridgeFlow turns a common event problem into a practical digital library solution.
Digital Workflow
Problem
Manual event lists create slow entry, repeated typing, unclear attendance status, and extra work after the event.
Objective
Build a low-cost, scalable, and easy-to-repeat digital check-in model for library events and professional programmes.
Technology Used
- Google Form registration
- QR ticket by email
- Smartphone scanning
- Google Sheets database
- Apps Script automation
Key Features
- Admin-only check-in
- Timestamp recording
- Duplicate prevention
- Participant database
- Certificate preparation support
Data Value
BridgeFlow turns check-in records into useful event data for reporting, planning, evaluation, and service improvement.
Scalability
The same system can be reused for orientations, workshops, seminars, reading programmes, training sessions, and CLA events.
Impact for Libraries
Faster event entry, cleaner attendance records, less repetitive staff work, easier certificate preparation, and stronger evidence for event reports.
Future Potential
BridgeFlow can grow into a wider library service model for digital engagement, user analytics, event planning, and community learning.
Project Context
Developed by Sim Chanbuntith, Senior Librarian, for the Cambodian Librarians Association (CLA) event The Reading Bridge 2026: Cambodia–Italy Intercultural Literacy Initiative, June 2026.