Forum Discussion

NikkiWalters's avatar
NikkiWalters
Qrew Cadet
7 years ago

Link Member Records for Grouping for One Team Report

My "Teams" table contains multiple "Team Member" records for each Account.  Accounts cross many Teams and have multiple Members & Managers.  I can easily report on all Accounts showing all Members ac...
Formulas and functions
Relationships
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
If you can make a formula checkbox field on the child table called [This member reports to Current User] with a formula something like

User() = [manager userid]

Then you ca make a summary count on a relationship of the of the [# of members who report to the current user].

Then you can filter a single report on that being >0 and send to all managers.