Customers often want to track stats about the resources they’re scheduling in DayBack. They want to answer questions like…
“How many hours do these assignments represent?”
“What is the total cash value of the confirmed bookings this week?”
Stats like these are easy to add to DayBack and this post describes two different methods for calculating them.
Like many developers, I usually think of using relationships first when deriving date-range stats like these. While that works, I’ll suggest that using find requests is much easier and results in code that requires a lot less maintenance as your requirements change. A description of both approaches follows, along with unlocked example files.
In our examples, we’ll total a new field in the events table called “Cash Value” and count the number of events in a given week.
This short video shows what we’re trying to accomplish and introduces the two different techniques.
Step-by-step instructions for each technique follow below in case you’d like to add this capability to your copy of DayBack. And here are the unlocked example files for each approach…