Creating multiple Records with a year change

Hey guys,

So I have an accumulated vacation table that uses an employees start date and a duration formula to determine how much vacation / sick time they have earned based on their years of service with us. What I would like to do is create an automation that is capable of creating a record for every “active” employee when the calendar year changes. This would essentially create 50 some records on 1/1/20xx detailing an employees accum. vacation and sick time.
I have to have a record for each annual year becuase I use another table to track an employees attendance in regards to Birthday, vacation days, sick time used that subtracts hours used vs hours accumulated.

Thanks for any tips in advance!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.