How to select a value of a column

[Jesus_Corral]

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

Explanation
I have 2 tables

Employees
Number (id)
Name (text)

Timesheet
SCANNER_CARD (References to the Number of Employees table)
Time in (time)
Time out (time)
Date (date)

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)

But

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 .