Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Turn a period into records per day automatically with trigger

Topic Labels: Automations
290 0
Showing results for 
Search instead for 
Did you mean: 

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