if you want to display only the demands
find all team member demands where user is in do a search for team member where user = current user and role = manager each item’s user
if you want to split by teams
search for all team members where user = current user, role = manager, each item’s team unique elements
then inside the cell, search for Team-Member-Demand where user is in search for Team-Member where team = current cell’s team
if you want to save on workflows
Team-Member
user
team
role
demands_cached (list of team-member demands)
the demands_cached list should populate on a database trigger when a new demand is created and then added to the appropriate team member. This will reduce the lookup since now you’ll have access to the demands on the team member lookup itself. You could apply this same logic to the ‘Team’ too, a list of members_cached
You’ll probably want data to show who viewed/approved the demand as well and you may want to separate it out by teams anyway because if a non-manager is part of multiple teams, you’ll have conflicts with approvals (what happens if one manager approves and the other doesn’t? what system is setup to rectify that?)
