And the issue with that is that the App is HUGE. So I can't use formula queries without affecting performance. ERG! :)
Hmm. Does modifying the query to cap it at only caring about dates in the next 6 months help at all? Like if you make an if statement that if the date is before this month or after 6 months from now don't do anything so the query is a little lighter on the table?
Otherwise, does it need to be real time or can it be some kind of daily review of your day records? It would be kind of taxing on QB to evaluate the entire subset of days each day so you might need a way to control / limit the results of what you're checking everyday - but you could take the formula query concept and put it into a Pipeline.
So lets say someone enters a new PTO request for 12/21 - you can have a daily Pipeline that runs, or just run based on that PTO event and in the pipeline do the same query using 12/21 as your baseline. If the number of records in your response is 15 - check a box on the day that says it fails the test. This comes with a tax in that you then have to bind it in a way that if the PTO request changes you'll have to undo that check so it's open unless it fails a different test.
If you're able to program and go the custom route you can always just take this out of Quickbase natively and write a script where you can query the days in the future and using whatever programming language you choose have a function do an actual loop and count them up and write back issues to QB. Way more complex in that sense, but figured I'd toss it out.
------------------------------
Chayce Duncan
------------------------------
