I have a form with a multi-select field to indicate the team(s) involved in each entry. There are 5 teams which the user can select (A, B, C, D, E). For entries where more than 1 team is involved, the user can select more than one option.
When I use the Table Filter macro on the TableView of this confiform and filter based on the team(s) field, I am unable to filter to display all the items in which team A is involved in. Instead, the filter dropdown options are the possible combinations of teams, e.g. (A, AB, AC, ABE,...).
Instead I would like to be able to have a filter drop down of A, B, C, D and E such that selecting one will show all the entries in which the team selected is involved in. How can I do this? Thank you!
