Hi guys, I hope you are fine, I’m hoping someone can help me with this please !
What the application is about?
Automated application for recording employee check-ins and check-outs by barcode scanning
I have 2 tables
SCANNER_CARD (References to the Number of Employees table)
Time in (time)
Time out (time)
The process is this :
1.- I have an EMPLOYEE VIEW in which I can add, delete, edit an employee.
2.- I have a TIMESHEET VIEW which is where employees will be scanned for check-in and check-out
The situation is this:
I couldn’t find a way for the application to give me an entry or exit time depending on the employee being scanned
View of the timesheet form:
Here for example an employee has been scanned and automatically gives me the check in (TIME IN field)
How can I define a function or query that allows me to identify whether the employee being scanned displays the time of check-in or check-out? ( to proceed with the calculation of hours worked)
I don’t know how to translate the query into appsheet language
please if anyone can help me I’d be very grateful, I’ve had this problem for over two weeks, please .