Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

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

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".
  • 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()))