ROLC QR Attendance

⚠ Offline — scans queued locally

⬛

Tap Scan to activate camera

Ready

Step 1 of 4

Set Up Google Sheet

This app uses Google Sheets as its database — accessible from any device, anywhere. Your data stays in your own Google account.

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. Add these 3 tabs with exact names:

📊 Attendance
  Row 1: ATTENDANCE (title row)
  Row 2: Username | Timestamp | QR Code | Name | Group

👥 Members Sheet
  Row 1: QR CODE | NAME | GROUP

🔐 Admin
  Row 1: Username | Password

Step 3 of 4 — Google Sheet

Add the Apps Script

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

Step 4 of 4 — Google Sheet

Deploy as Web App

1. Click Deploy → New deployment
2. Click the Select type gear → Web app
3. Execute as: Me
4. Who has access: Anyone
5. Click Deploy → Authorize → 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 upload

Data Transfer

Move scans from Attendance sheet into per-date sheets for long-term storage.

Sound / Vibration

Scan feedback sounds

On

ROLC

River of Life Choir

QR Attendance Scanner

Version:
Updated: 2026-07-16
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.

⏳ 0 pending