This definitely seems like a really cool usage of AppSheet! I have built something similar, so I might be able to help out here.įrom just quickly reading this, am I correct in assuming that this seems to be an issue with not allowing duplicate ?Īlso, is there a specific reason why you have clock in and clock out on separate tables as opposed to as a single row? How do I make it so that the app can allow for Multiple Clock In/Clock Out per day without relying on the Vlookup table? “Clock Out” Form where scanning a QR Code automatically logs the Staff’s ID, Date, and Time Out into the Clock_Out tableįrom that, the Vlookup will provide the corresponding value for the Clock_In table.“Clock In” Form where scanning a QR Code automatically logs the Staff’s ID, Date, and Time In into the Clock_In table.Clock_Out contains the fields for, ,, and.is a concatenation of and to provide a unique field to generate a VLookUp for Clock_In contains the fields for, ,. ![]() Master_List is ReadOnly and contains all Staff details. ![]()
0 Comments
Leave a Reply. |