Turn a period into records per day automatically with trigger

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