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