Good afternoon friends,
I have a question about how to call an action:
I have 2 tables [Time entries] [Log entries].
[Time Recording]
id Records (Uniqueid()); id Employees; Status (open)(closed); Date (Today()); Entry 1; Exit 1; Entry 2; Exit 2; QR Code (id Employees).
[Log Records]
idLOG; id Employees (QR Code); Date (today()); Status (Open)(Closed); Hours; Log (DateTime())
What I'm trying to do is, in the form of the [Log Records] table, when reading the QRCode check if the [Employee id] already has a record with the Date (Today()) and Status (Open). If the return is false, add a new record to the [Time Log] table with the data id Employees, Status (open), Date (Today()), Entry 1 (TimeNow()), Log (DateTime()). If the return is true, check which first record is empty (Output 1, Input 2, Output 2) and update.
I hope I was clear... lol...
Thanks
Translated with DeepL.com (free version)
LinkedIn
Twitter
