Hi guys,

I am part of a small business of football, we do plenty of sessions for kids and now we can to start keeping track of who comes and who doesn't to then ask and know why they are not attending...

We are looking at buying a barcode scanner to put up at our events, and then each person would be given an id card with a barcode in it... There is a couple of things I'd love to know to have it all working...

Firstly... How do you make sure the barcodes are linked to the persons info? Like name number etc... How does the machine knows that info so that after scanning it goes atumatically where it should? Mainly if ID and barcode number is xxxx, hoe does it know that xxxx is ie John Doe, mobile number x, venue.

Second, and maybe the biggest issue, I'm no programmer or anything, I have very basic but steady knowledge of excel and other programs, I heavily rely on finding stuff on the internet and following steps... So I have no idea how to start, create, or after getting it, modify an excel spreadsheet with what we need.

If anyone could help me solve this it would be heavily appreciated!

What I'm looking for is a simple spreadsheet for attendance.
First, having the list of all the members that could attend any of the events on different venues (3 or 4). So in that info sheet, we will see name, mobile number, and venue. If we have more people registering, being able to add to that list, with a new code and barcode...
Second, an automated sheet on which after the kids scanning their id/barcode, it comes up with a yes or a 1 or something that tells me the kid attended at a certain date, without me necessarily clicking something as "I can verify he is here" or whatever. Scans and he is in (only once hopefully...).

All we will see at the end is a nice sheet with the whole attendance after being scanned. Maybe colour in red the box if the kid didn't attend, although that is not a must...

If anyone can give us a hand with this, I'll be forever thankful. We are a very small business but we try our best to grow and to make it work as good as we can for the kids.

Any other info you might need please tell me, after all, you are the ones helping!

Thanks in advance!