ROLC QR Attendance

Username

Password

Attendance

⚠ Offline — scans queued locally

⬛

Tap Start Scanning
to activate camera

Ready

Step 1 of 4

Set Up Google Sheet

This app uses Google Sheets to store attendance data — accessible from any device, anywhere.

Setting up an additional device?

Step 2 of 4 — Google Sheet

Create Your Google Sheet

Go to sheets.google.com and create a new spreadsheet, or upload your existing XLSX to Google Drive and open as a Sheet.

Create 3 tabs with these exact names:

📊 Attendance
  A1:E1 = ATTENDANCE (merged)
  A2=Username, B2=Timestamp, C2=QR Code, D2=Name, E2=Group

👥 Members Sheet
  A1=QR CODE, B1=NAME, C1=GROUP

🔐 Admin
  A1=Username, B1=Password

Step 3 of 4 — Google Sheet

Add the Apps Script

In your Google Sheet: Extensions → Apps Script. Delete existing code and paste this:

Step 4 of 4 — Google Sheet

Deploy as Web App

1. Click Deploy → New deployment
2. Gear ⚙ next to Type → Web app
3. Execute as: Me
4. Who has access: Anyone
5. Click Deploy → Authorize
6. Copy the Web app URL

Done — Google Sheet

Paste Web App URL

Web App URL

🎉 All Set!

Your ROLC QR Scanner is ready to use.

Active Database

Not configured

Google Sheet URL

Not configured

Pending Sync

0 pending

River of Life Choir

QR Attendance Scanner

Version:
Updated: 2026-03-09
Built by: HALQ
Repo: github.com/BossArQue/ROLC-QRScanner

Libraries

html5-qrcode 2.3.8
Google Fonts: Outfit, DM Serif Display, DM Mono

© 2026 HALQ. All rights reserved. • Created by HALQ • Project for ROL Choir 2026
This software is proprietary and confidential.
Unauthorized copying, modification, distribution, or use is strictly prohibited.