AND / OR for each condition when filtering data


It will be useful to have the option AND/ OR for each condition when filtering data for a collection


this is the approach in airtable for example, and for each condition you can choose AND or OR

I agree that would be useful. It’s not perfect but one workaround is to create your ‘And’ leg in the data editor then combine that on the front end with ‘Or’.

E.g. in the data editor we have an ITE column with 5 ‘And’ statements. On the front end we use that ITE column in our filter with additional ‘Or’ statements.

@Eric_Penn thanks for the response, I’ll try that, but do you think the option to have it in the layout will also be implemented ?