Forum Discussion
MarkShnier__You
Qrew Legend
3 years agoOne choice is to make a single record helper table called dashboard filters. So create that table and create a single record and then block anyone including the admin from ever adding or deleting records in that table.
The record ID of that single record will of course be 1. Make a relationship from this table down to your detailed tables based on the reference formula field that calculates to 1. The formula will be 1.
You can create any filters like date ranges or "Regions - whatever .....", on your settings table and look those up down to your details tables. Create reports which you will use on the dashboard which will respect those filters. Put the single record table report on your dashboard so users can easily edit their filters there.
For the filters on your report be sure to deal with a situation where the user leaves a particular filter blank. You want to make sure the report will result in all records if a filter is left blank.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
The record ID of that single record will of course be 1. Make a relationship from this table down to your detailed tables based on the reference formula field that calculates to 1. The formula will be 1.
You can create any filters like date ranges or "Regions - whatever .....", on your settings table and look those up down to your details tables. Create reports which you will use on the dashboard which will respect those filters. Put the single record table report on your dashboard so users can easily edit their filters there.
For the filters on your report be sure to deal with a situation where the user leaves a particular filter blank. You want to make sure the report will result in all records if a filter is left blank.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- DanielMarshall3 years agoQrew MemberThank you Mark, much appreciated!
------------------------------
Daniel Marshall
------------------------------- MarkShnier__You3 years ago
Qrew Legend
I should've also mentioned that if you have several users acting concurrently they will step on each other's toes as the settings are being put into a single record ID number 1.
There is another approach which is a little more complicated to set up where the user selections are set in a table of users where the Key Field is the user ID. Under that set up then you can have as many users making changes as you want and they won't step on each other.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------