Forum Discussion

PedroRocha's avatar
PedroRocha
Qrew Trainee
8 years ago

How do I create multiple child records by specifying a date range?

So I have two tables. One for Employees and the other for Vacation Time. How do I create multiple entries on the Vacation Time table at the same time, by selecting a start date and an end date?  Th...
MichaelBarrow's avatar
MichaelBarrow
Qrew Cadet
8 years ago
I had this exact same need and had to hire a consultant to create a script. It is 200 lines of code. It works great, but at a high cost relative to a non-code solution. I would love a non-code solution. I don't know how it can be done, though. I would be interested in possible suggestions too. One thing that greatly facilitates my script is a Calendar table that has one record for every business date. The script can pull a subset of those records between the start and end dates to drive the looping.
MichaelBarrow's avatar
MichaelBarrow
Qrew Cadet
8 years ago
Yes, I find that stuff like this is a pretty common need for us in a number of areas. Here's a screen shot of some of the fields I have in my Calendar table. The Date field is the primary key so that I can easily relate it to any other table that has a date field.
https://www.screencast.com/t/N4by4u8kAoL

I also use a system variables type of table that I call Parameters that has one record with Record ID# = 1 that  I relate to all other tables through a  numeric formula field = 1, and that has some important date-related and month-related fields for where we are in our monthly and yearly business cycle.

These two tables make everything date-related a whole lot easier.