Filter records in a parent table based on a "User - List" field in a child record

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
I'm managing a database for a sports league. I have a table of "games", and a table of "teams", connected through a many-to-many relationship with a "teams at games" table. Each team has a user list field where the league commissioner adds every team's coach. I'd like to make a report in "games" that only shows records applicable to the relevant coach/user. Its similar to this question (https://community.quickbase.com/quickbase/topics/filter-records-in-a-report-for-a-parent-table-based...) except that post had a solution that only works when the child table has a field of type "User" and not "List - User".
Photo of Adam Dowell

Adam Dowell

  • 90 Points 75 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,570 Points 50k badge 2x thumb
You can put a formula checkbox field like this on the Teams at Games called [This is Current User's Team]


Includes([Team members], ToUserList(User()))