Forum Discussion
MichaelBarrow
7 years agoQrew Cadet
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.
- PedroRocha7 years agoQrew TraineeMichael thank you for replying. I thought this would be a very common issue among Quick Base users but you are the only person I found with this same need. At this point I'm considering every option.
Did this Calendar table have all business dates for the whole year? - MichaelBarrow7 years agoQrew CadetYes, 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.