Report Goal: User inputs the Friday for the weekend they would like to see what items are Starting or Ending during that weekend (Saturday, Sunday, Monday).
So Far: I've set up the <Ask the User> to input both the start/end dates. I've also set up a formula field that looks at the Start and End Dates and assigns the day of the week to them.
Issue: I cannot find a way to indicate ONLY DURING THE WEEKEND INDICATED between the start and end dates and have it be available any time based on the start and end dates input by the user.
For now, the report is pulling properly if you pull it during the week before the next weekend, but if you were to pull it over the current weekend (say on Sunday), you will not see the items from Saturday. The other issue is that even if I put in the dates from last weekend it still only shows this weekend's information because of the second line in my report criteria (7 days in the future - which always means 7 days from TODAY, not from the date indicated by the user). Is there a way to do + or - 4 days from date indicated?
Thanks for any creative ideas on making this happen!! I've included a screen shot on how I've set up the criteria, I probably would be able to make this happen with one more level down but Quickbase does not want me to go there!
So Far: I've set up the <Ask the User> to input both the start/end dates. I've also set up a formula field that looks at the Start and End Dates and assigns the day of the week to them.
Issue: I cannot find a way to indicate ONLY DURING THE WEEKEND INDICATED between the start and end dates and have it be available any time based on the start and end dates input by the user.
For now, the report is pulling properly if you pull it during the week before the next weekend, but if you were to pull it over the current weekend (say on Sunday), you will not see the items from Saturday. The other issue is that even if I put in the dates from last weekend it still only shows this weekend's information because of the second line in my report criteria (7 days in the future - which always means 7 days from TODAY, not from the date indicated by the user). Is there a way to do + or - 4 days from date indicated?
Thanks for any creative ideas on making this happen!! I've included a screen shot on how I've set up the criteria, I probably would be able to make this happen with one more level down but Quickbase does not want me to go there!
-
354 Points
Posted 4 years ago
QuickBaseCoach App Dev./Training, Champion
-
65,796 Points
-
354 Points
-
354 Points
To answer my own question for the community:::
And using this solution as a great starting point: https://quickbase-community.intuit.com/questions/1170581-display-todays-people-on-vacation-when-date...
I've created 4 constraints for <ask the user> essentially asking, what is your Start Date Min. Date, Start Date Max. Date, End Date Min. and End Date Max.
Then on the back end I've only included dates that have Sat. Sun. or Mon. as their Day.
The report than shows anything that falls into the Start Date Min-Max OR End Date Min-Max.
Here's what it looks like in the report backend and for the user - not the prettiest, but it is adaptable to select multiple weekends at a glance whenever it is needed (not only showing THIS weekend).
And using this solution as a great starting point: https://quickbase-community.intuit.com/questions/1170581-display-todays-people-on-vacation-when-date...
I've created 4 constraints for <ask the user> essentially asking, what is your Start Date Min. Date, Start Date Max. Date, End Date Min. and End Date Max.
Then on the back end I've only included dates that have Sat. Sun. or Mon. as their Day.
The report than shows anything that falls into the Start Date Min-Max OR End Date Min-Max.
Here's what it looks like in the report backend and for the user - not the prettiest, but it is adaptable to select multiple weekends at a glance whenever it is needed (not only showing THIS weekend).
