Skip to main content (Press Enter).
Skip auxiliary navigation (Press Enter).
Quick Base University
Skip main navigation (Press Enter).
on this day
between these dates
Back to discussions
sort by most recent
sort by thread
We run a Lab and are hoping to build a heireachy where certain Sales managers will be able to see re...
You can build a permissions table, where salesperson or sales territory is the primary key and sale...
I would just add a field of type User to the sales rep table called [Manager Userid]. Then look up...
Posted 11-25-2017 14:15
We run a Lab and are hoping to build a heireachy where certain Sales managers will be able to see revenue activity for all of their salsepeople. I am not sure how to do this. Any advice will be appreciated.
Posted 11-25-2017 16:33
You can build a permissions table, where salesperson or sales territory is the primary key and sales manager is another field in the table. Then bring these fields in as a lookup field in the tables where your revenue data lives - at that point you can either use role permissions or report filters to show the relevant data to sales persons and sales managers. Using permissions is less work but also less flexible.
Posted 11-25-2017 19:41
I would just add a field of type User to the sales rep table called [Manager Userid].
Then look up that field down to the Revenue Activity table.
Then set up a custom permission for the role of sales manager where they are allowed to see Revenue Activity where [manager userid] is the current user.
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Powered by Higher Logic