Forum Discussion

KatherinePark's avatar
KatherinePark
Qrew Trainee
4 years ago

Dashboard Help

I have a table that has several supervisors and each of those supervisors has employees. The dashboard is set up to view that table and a few reports off that table. The supervisors are set up as users in the quickbase with the role that uses that as it's main dashboard. How do I get the dashboard to only show the employees of the supervisor that is logged in? The supervisor cannot see the other employees in the table only their own.

------------------------------
Katherine Park
------------------------------
  • If the records that are being shown on any report (including reports used on the dashboard) have a field for the UserID of the supervisor then the reports can be filtered to only show employees where the supervisor is the current user.

    However that is not true security. If you really want proper security and there is an ironclad rule that supervisors may only see their own employees, then you want to control all this through Role permissions. 

    You would set up a role called supervisors can only see their own employees and put in a custom rule that says that the supervisors are allowed to view and perhaps allowed to modify employees where the supervisor user ID is the current user. 

    If you do that then you do not have to worry about filtering any reports because the Role Permissions will take care of that for you. With Role permissions,  users in those permissions just live in a smaller world than unrestricted Users.  They don't see what they don't see and they won't know what it is that they're not seeing.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • KatherinePark's avatar
      KatherinePark
      Qrew Trainee
      I have a team lead role. The user name is in the table as the team lead unique ID. I have a custom rule for the role. What am I doing wrong?
       

      You would set up a role called 
      supervisors can only see their own employees and put in a custom rule that says that the supervisors are allowed to view and perhaps allowed to modify employees where the supervisor user ID is the current user. 

      ------------------------------
      Katherine Park
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        Do you have a userid field type.  What field type is TL ID.  If it is a user field then it should offer you up the choice to filter on current user (as a drop down choice), but if  not you can make a formula user field called [Current User] with a formula of 

        User()

         and filter on that.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------