Free QR Code Attendance Kit

Everything you need to run QR code check-in with a free Google Form and Google Sheet: a printable door sign with a space for your QR code, a backup paper sign-in sheet for people without a phone, and a one-page how-to with the exact form questions and the formulas that turn check-ins and check-outs into hours.

Made by Arden Pala, founder of Helptivo. Updated November 7, 2026. Free to copy, edit and share.

Download

No sign-up or email needed. The links download the file directly.

Page 1: door sign. Page 2: backup paper sign-in. Page 3: the how-to. (Tap to enlarge.)

How to set it up

  1. Make the form. In Google Forms, add four required questions: Full name (Short answer), Email (Short answer), Event (Dropdown, one option per event) and Checking in or out? (Multiple choice: Check in, Check out).
  2. Link a Sheet. On the Responses tab, click Link to Sheets. Answers land on a tab called Form Responses 1, in columns A Timestamp, B Full name, C Email, D Event, E Checking in or out?
  3. Make the QR code. Click Send, choose the link icon, tick Shorten URL and copy it. Open the link in Chrome, right-click and choose Create QR code for this page.
  4. Print the kit. Paste the QR code in the box on the door sign. Put the backup sheet on the table.
  5. Add an Hours tab. Add a tab called Hours. Type Email, In, Out and Hours in A3 to D3, and the event name in B1, spelled exactly as in the dropdown. Paste the formulas below, copy B4:D4 down, and format columns B and C as Time.

Formulas for the Hours tab

A4:  =UNIQUE(FILTER('Form Responses 1'!C2:C, 'Form Responses 1'!D2:D=B1))

B4:  =IF(A4="","",MINIFS('Form Responses 1'!$A:$A, 'Form Responses 1'!$C:$C, A4, 'Form Responses 1'!$D:$D, $B$1, 'Form Responses 1'!$E:$E, "Check in"))

C4:  =IF(A4="","",MAXIFS('Form Responses 1'!$A:$A, 'Form Responses 1'!$C:$C, A4, 'Form Responses 1'!$D:$D, $B$1, 'Form Responses 1'!$E:$E, "Check out"))

D4:  =IF(OR(N(B4)=0, N(C4)=0), "", ROUND((C4-B4)*24, 2))

These assume the column order in step 2. If you collect verified emails, Google adds its own email column, so change the letters to match.

If your school uses Google Workspace, you can set Collect email addresses to Verified in the form's settings. People then sign in with their school account to answer. That stops most check-ins for absent friends, but guests without an account can't check in, so keep the paper sheet out.

What's in it

  • Door sign: "Check in here", blanks for the event and date, a large box for the QR code and three short steps, including "Leaving? Scan again and choose Check out."
  • Backup paper sign-in: 24 rows with name, email, time in, time out and initials, and a line for the officer who adds them to the Sheet afterwards.
  • One-page how-to: the steps above, the formulas, an example of the finished Hours tab and the honest limits below.

The honest limits

  • Anyone with the link can answer from anywhere, for anyone, unless you use verified emails.
  • People forget to check out. Their hours stay blank until you fix them.
  • A typo in an email splits one person into two rows on the Hours tab.
  • You get hours per event. A running total per member needs another tab with SUMIF by email.

Doing this in Helptivo

Helptivo does this out of the box. Each event gets its own QR code, members scan with their phone camera to check in and out, and hours go on their member profile with no formulas. It has the same two weak spots: there's no identity check, and someone who forgets to check out counts as attended with 0 hours until they check out. A check-in window and an optional 5-digit checkout code cut down on friend check-ins. Free for up to 150 members. Start a free club, or read about attendance tracking.

Questions people ask

Can I take attendance with a QR code and Google Forms for free?

Yes. Make a Google Form, link it to a Google Sheet, turn the form link into a QR code and print it on the door sign in this kit. The how-to page in the PDF walks through each step.

How do I make a QR code for a Google Form?

Copy the form link from Send, open it in Chrome, right-click the page and choose Create QR code for this page. Any free QR code generator works too.

Can people check in for a friend?

Yes, unless you turn on Verified email collection, which makes people sign in to a Google account. Even then, check the timestamps. No QR check-in can prove who is holding the phone.

What happens if someone forgets to check out?

Their Hours cell stays blank on the Hours tab. Ask when they left and type it in, or add a Check out answer for them.

Do I need a new QR code for every event?

No. One form and one code can cover every event, because the form asks which event. Add each new event to the dropdown.