I have the following initial situation
The opening hours of my business are defined from Monday to Saturday and vary in length. Furthermore, more than 10 people work in my company, with whom I have to cover the opening hours. This means that each employee has different working hours per weekday. These working hours differ from employee to employee. So the absences of my employees are not calculated in days but in hours.
Employee 1: Monday 8 hours, Tuesday off, Wednesday 8.5 hours, etc.
Employee 2: Monday 9 hours, Tuesday 7.5 hours, Wednesday off, etc.
What I would like to achieve now:
- By means of a form, an employee should be able to request “absences”. He should enter in one or more datepickers the dates on which he would like to be free. Once the form is submitted, a new “vacation entry” should appear in Airtable, which, based on the example above, displays the correct number of hours for the employee for the day in question, and this is then deducted from a predefined balance (100 hours).
Is this feasible? If so how?