Hi guys, I hope you are fine, I hope 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)
And I add an slice called IN of the TIMESHEET table and its function is to store all the people who have already registered with the time of entry to work
Timesheet form where employees scan a bar code to check in
Slice which shows the employees who have already made their check in
Here is the problem that I have
if I click one of these employees to see more details, I have a button that I added called clock out, is an action button which causes the employee to clock out and then shows me the hour of clock out
But I don´t want to do this because
the purpose of the app is that the employee just need to scan their card and automatically the app must record their entry time as well their out time.
So I thought if there is a way, a condition, a query, something that helps me to interpret the following:
if the employee being scanned in the TIMESHEET FORM has already records in the table IN which is a slice then give me the time out of this employee.
The problem is that I don’t know if you can do something like that, and in case of being possible, where I would put that condition and how I would translate it into appsheet language.
I hope you can help me. Thank you.