Filter for several attributes

Hey there :waving_hand:,

For my little event app I would like to build a feature with the following logic:

I want to let events appear based on a filter which is essentially not a problem. However, I am not able to make it work if I want to filter for several attributes e.g. filtering for an event that is suitable for families and explorers as in the attached example.

Could someone help me setting this up properly? Thanks a lot :folded_hands:

You can add many columns to filter by in the collection’s Options screen.

You can also create customer filters but creating a helper table and add a query column to your data. You then add user-specific columns and add those as part of the query you created. In the UI, add choice components for those user-specific columns and and then a collection that points to your query column.

For your case, is the filter we’re talking about here a native filter in a collection?

When you say “Families and Explorers”, would the filter work as an OR, or would it be an AND (both choices must exist in the entry’s record).

It should work as an AND e.g. someone should be able to search for an event that is “indoor” and for “families”

Are “indoor” and “families” considered two different attributes, in different columns, for each record?

Also, can you answer this?

Or is it a different kind of “filter”?

To your first question:
Yes, two different attributes in two columns

2nd question: I think I solved half of the problem by simply adding two in app filters. However, if I choose several attributes from one filter all events are shown that match at least on attribute. I am looking for a solution where the event would just be shown if it matches all attributes.

Yeah, that’s why I asked you if you are using a “native” filter.

In this case though, native filters won’t be enough as you have found out.

You would have to use a variant of this to match it that way, using user-specific columns to store your “filter” values.

1 Like