Discussions

Expand all | Collapse all

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

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

    Top
    Contributor
    Posted 07-27-2018 21:28
    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...">https://community.quickbase.com/quickbase/topics/filter-records-in-a-report-for-a-parent-table-based-on-details-of-a-child-table">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".


  • 2.  RE: Filter records in a parent table based on a ""User - List"" field in a child record

    Posted 07-27-2018 22:17
    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()))