Hi beautiful Airtable’s community !

I have a problem with my work time sheet. I am looking to count paid time off as a normal work day


I don’t want the employee to have to enter his days off one by one,


so that they are counted in my total hours. (and be counted as paid time off)

I think the solution is towards automation with a script and the function of Parent record in child record

1. When a form is sending (with the name, and ID on employee)



2. with “congés de fin d’année/christmas holiday” → a condition



3. from 1 to 5 December → date
   
   
   
   
   

So create/duplicated a record


with same information BUT one by day of holiday.

Make sense ? Thanks in advance for your help