Forum Discussion

DanielMarshall's avatar
DanielMarshall
Qrew Member
3 years ago

Applying filters at the report widget level vs. to the entire dashboard



------------------------------
Daniel Marshall
------------------------------
  • One 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
    ------------------------------
    • DanielMarshall's avatar
      DanielMarshall
      Qrew Member
      Thank you Mark, much appreciated!

      ------------------------------
      Daniel Marshall
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew 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
        ------------------------------