Dashboard Dynamic Filter for Multiple Reports
I am moving one of our teams from an Access Database to the QB Platform. In Access, they had a Dashboard that they really liked, but I'm not sure that it can be duplicated in QB. The screenshot shows ...
Forum Discussion
I've always wanted to toy around with this so I made an app in the builder program. I have a Data table and then a User Filter table with a relationship that has the related field as a formula to use the current user. I bring the filter data over and use a formula checkbox to determine what to show. On the dashboard is a button that goes to a grid edit report in the user filter table to set the filter where the user can set their filter. I also have it set to show everything if no filters are applied.
Anyway it is all setup in an app I can share to you. I will make you an admin and you can test in the 'participant' role. All I need is an email to invite you to the app. I only ask you don't make structural changes to the app and if you have questions I can help out.
------------------------------
jason johnson
------------------------------
Anyway it is all setup in an app I can share to you. I will make you an admin and you can test in the 'participant' role. All I need is an email to invite you to the app. I only ask you don't make structural changes to the app and if you have questions I can help out.
------------------------------
jason johnson
------------------------------
- You could post it to the app exchange and not have to worry about someone changing the architecture of the app in your realm.
------------------------------
Adam Keever
------------------------------- I plan to put it out there once I get some time to clean it up. It is in my builder program realm but I just realized I have an app in there to delete so I can copy the filter app.
------------------------------
Jason Johnson
------------------------------Sorry I went MIA on this, I was off for a while unexpectedly, but am now back! I am very much a visual person and would really appreciate seeing your app, Jason. I'm not sure if Mark's solution would work in this case, unless I'm not understanding something. This particular app only has two users, one for data entry and the other a manager. The manager needs to be able to run reports using the client manager filter, not a user filter, since each client manager isn't a user. We hope that to change eventually and that they will all be users, but at this time that's not the case.
------Original Message------
I plan to put it out there once I get some time to clean it up. It is in my builder program realm but I just realized I have an app in there to delete so I can copy the filter app.
------------------------------
Jason Johnson
------------------------------
