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 user...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIf 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
------------------------------
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
------------------------------
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
------------------------------
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__YouDo 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
------------------------------- I GOT IT! THANK YOU!
------------------------------
Katherine Park
------------------------------ - AHHHH ok so the type of field needs to be a userid field. The TL ID is their user ID. But I think the field type is something else. I will go look at that!
------------------------------
Katherine Park
------------------------------- When I changed the field to a User type field (it was text) it made the Id's in quotations "A123456" Is that what it is supposed to do?
------------------------------
Katherine Park
------------------------------
