Help ! QR Codes as Time & Attendance

[Mattgreenman]

I'm sure this has been covered many times before... however I'm a basic user of excel so need some help please.

So I manage 200 volunteers at a music festival, when they sign up, they are issued with a QR Code. I have a suitable scanner etc. What I'm looking for is a very basic spreadsheet, that I can in one sheet, list off their first and second name, and their QR code.

Then on a second sheet (data) record their name, date, time, then if its IN or OUT.

I'm guessing then a form that can grad the QR select in or out and then populate the data sheet?

Has anyone got anything I can use or modify within my basic understanding

[ELeGault]

Its not as easy as "Its a QR code so heres the form"

Scan a few items and share the OUTPUT that you are getting.
Then someone here can assist you with setting up a "Reader" for the data to capture the specifics you wish to get out of the scanned data.

[Mattgreenman]

thanks... I'm not looking to do anything with the scanned data, other than use it to match with the persons name. We can pre-scan the code before hand and assign to someone if that makes sense