Hi!
I have a system to record the working hours of employees. Through the form in table "timestamp", each employee reports the time of arrival and departure (and lunch break). Each entry is in a new line. Then, in table "Presence at work", I combined these rows for each employee to have all check-ins/check-outs for one day in one row. In this way, I then calculate lunch break and work time. If I group the rows by name and date, I can get a monthly attendance statement.
In a completely different table ("holidays leave"), vacation requests are submitted via a form, where vacation days are added up.
Now, in the table "Presence at work" (or in some extra table), I would like to have a monthly display for each employee of how many hours he worked, how many hours he used vacation and sick leave, and how many hours of holiday there were.
Any ideas on how to make it as easy and automated as possible? So that I don't have to connect the tables manually.
So how to add those missing information in the table here:
Or if you have any better solution?
I created a base copy (without automations) ad share it, if anyone is willing to take a look: https://airtable.com/invite/l?inviteId=invwcjzcY5ObD0Whc&inviteToken=0dd43c05bfe397698b168a8cb6b09db0b3a77fd1389d4c45c85d63bc034e7293&utm_medium=email&utm_source=product_team&utm_content=transactional-alerts
Thanks in advance.