I’m trying to generate weekly status reports from my project management app: it works, but I had to hard-code the date range for each week into a distinct view: so I have 52 views (for 2022), each of which hard-coded with a begin+end date range. I would much rather have a single view, with a filter that allows the user to select the date range and updates dynamically in response.
I thought I might be able to do this with an automation button, but there seems no obvious way to use the button to modify the filter. I did consider creating a one-row database which would hold the desired data range, and then use an action button with ‘update’ action to update that row, but then I couldn’t see how to use that value in the filter.
I also couldn’t see any way to provide a pre-determined list of date ranges for the user to select: I could create a 52-row database with the date ranges hard-coded, so the user could specify “week 1”, “week 2”, etc. (this would be ideal), but I can’t see any way to use that dataset in an action button: I seem to need the user to select a date range explicitly each time.
- ask the user to select from a list (“week 1” … “week 52”) pulled from my “Weeks” dataset (which defines the 52 weeks’ date ranges)
- use that selection to look up the date range from Weeks
- update the filter in the “weekly status” view to use the selected date range.
(Of course I’d be even happier to generate the user selection menu (“week 1” … “week 52”) programmatically, and then map the user’s selection to a date range programmatically, rather than using the “Weeks” dataset, but it’s no great hardship to create the “Weeks” dataset if that’s the only way.)
Ideally this would all be done (only) via the “weekly status” view, so that it would become a dynamically updating view controlled by the button. (To replace my current 52 different weekly status views).