The main function of my app is to scann a certain employee with a scanner field and the app has to give me the ENTRANCE HOUR as well as the EXIT HOUR in order to calculate the hours worked.
The thing is that the user has to scan a card that will be assigned in a field called SCANNER_CARD, and the app automatically has to show me the hour depending of the entry type , (ENTRANCE HOUR or EXIT HOUR)
I know that I can do the time funcionality with timenow() and other funcionts
but I don’t know how to automate this process.
What data do I have?
Table that has the following columns:
Table that has the following columns
SCANNER_CARD (References the NUMBER of the employee that is on employees
ENTRANCE HOUR (TIME)
What have I tried?
I have tried to use the MAXROW() function to identify the last value of the DATE-DAY column so that I can compare it to the penultimate value of the column DATE-DAY as well
I have tried to use the MAXROW() function to identify the last value of the DATE-DAY
but from the employee who was scanned not all data in general.
I don’t know how to implement this pseudocode in appsheet expression I’ve been researching the documentation for over two weeks and I can’t figure it out, please help me:
(assuming I already scanned the employee)
bring me the maxrow of the column DATE-DAY of the employee scanned
bring me the penultimate column of DATE-DAY of the same employee scanned
Please, I hope I’ve made myself clear. Thankyou