Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Turn a period into records per day automatically with trigger

Topic Labels: Automations
575 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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

0 Replies 0