@JonesyT ,
First of all, you would have to keep a List or a Table if you are using an Excel file, with all individuals. In this table, you would have to have a column that contains the barcode value for that user.
Then you can add a Barcode Reader media in the application and set the OnScan property to:
If(
LookUp(
ExcelTable, //your datasource - for you this will be your excel user list table
BarcodeColumn = First(BarcodeReader1.Barcodes).Value).BarcodeColumn, //Checking if user with this barcode value exists in user list
If(IsBlank( // if user exists in user list but no records registered then continue
LookUp(
LogTable, // your log table where checkins will be registered
UserID = First(BarcodeReader1.Barcodes).Value)), //UserID is column that will contain barcode value
Collect( // creates a new record for this user
LogTable,
{
User: "User1",
UserID: First(BarcodeReader1.Barcodes).Value,
'Check in time': Now()
}
)
)
)
This is just a simple way with what you can start with.
Later you can add more criteria and checks to exclude duplicated checkins for the same user for the same day, add checkout feature etc.
If you really are going to stick with Excel as your data source, then think what you are going to do when you hit the limit of 2000 rows of data, which you will eventually.
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!
