Google Forms for Attendance: The Problems and a Better Alternative

Putting a Google Form behind a QR code is one of the most common ways to take attendance: it is free, quick to set up and everyone knows how to fill in a form. For casual sign-ins it works well. For attendance that decides grades, payments, certificates or compliance, it has gaps you should know about.

Problem 1: the link never changes

Whether you share the link or print its QR code, it is the same every time. Once someone posts it in a group chat, anyone can fill it in from anywhere, during the session or hours later. You cannot tell who was in the room. How to prevent proxy attendance.

Problem 2: anyone can type any name

A form accepts whatever is typed. One person can submit the form five times with five names, or misspell a name so it does not match your list. Limiting responses to one per account requires everyone to sign in with a Google account, which many participants do not want or do not have.

Problem 3: no list of who was expected

A form collects responses; it does not know who should have attended. Working out who was absent means matching responses against your list by hand, session after session.

Problem 4: responses can be edited

Responses in the linked spreadsheet can be changed or deleted by anyone with access, with no reason recorded. That makes the record weak for any kind of audit.

Problem 5: reports are manual

Combining a form per session into a programme report, calculating attendance rates and deciding who gets a certificate is spreadsheet work every time. What a training attendance report should include.

Common workarounds, and why they fall short

• “Limit to 1 response” requires a Google account, which excludes participants without one and still allows people to fill it in from anywhere.
• Collecting email addresses tells you which account submitted, not who was in the room.
• Closing the form after the session helps a little, but anyone with the link can still respond while it is open.
• Using a new form per session stops old links working but multiplies the reporting work.
• Adding a “secret word” said in the room lasts until someone texts it to a friend.

When Google Forms is good enough

Forms are a fine choice for feedback surveys, event registration and informal sign-ins where nothing depends on the result. If nobody is paid, certified, graded or audited based on the list, the convenience may outweigh the gaps.

What to use instead

A dedicated QR attendance system fixes each of these:

• The code on screen changes every few seconds, so a shared photo stops working.
• Only registered participants can check in, with a personal code.
• One phone per person per session.
• Absences are visible immediately because the system knows who was expected.
• Sheets lock when the session ends; changes need a reason.
• Reports and certificates are generated automatically.

Moving from Google Forms

1. Export your existing responses or participant list to a spreadsheet and save it as CSV.
2. Import it as the participant list for a new event. Everyone gets a personal code.
3. Create a session for each meeting or class and show its code on screen.
4. Keep your form for feedback, where it works best.

QRtimer is free for one event with up to 50 participants, so you can try it on your next session. Compare QR attendance with forms and paper or read the setup guide.