Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
The Project manager table seems to be a list of individual users. Set the Key field for that Table to be the Userid.
Then on any details table you like, for example the Projects table you can create a Formula User field called [Current User] with the formula of
User()
Then make a relationship and lookup any information about the Current User down to the details table, such as Projects, so for example look up the Delivery Team and call it [Current Users Delivery Team] Then use that in a report filter to match on Delivery Team.
Then on any details table you like, for example the Projects table you can create a Formula User field called [Current User] with the formula of
User()
Then make a relationship and lookup any information about the Current User down to the details table, such as Projects, so for example look up the Delivery Team and call it [Current Users Delivery Team] Then use that in a report filter to match on Delivery Team.