• 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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.
Photo of Matt Ryan

Matt Ryan

  • 70 Points

Posted 1 year ago

  • 0
  • 1
Photo of Kevin O'Boyle

Kevin O'Boyle

  • 602 Points 500 badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,908 Points 50k badge 2x thumb
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.