Filtering and sorting are powerful tools that help users find and organize data more efficiently. Filtering allows users to narrow down a list of items based on specific criteria. While sorting helps users arrange items in a specific order.
This feature is only available on List Screens (View Items/Update Items).
This is different from Notion databases filtering and sorting because you can create multiple apps with different filters and sorts and provide it to multiple groups of users.
To filter or sort items, open the app builder. Go to the desired screen through the app preview. Click on "+ Add Filtering", "+ Add Sorting" to add filtering or sorting.
To add filtering, click on "+ Add Filtering". This will add a default filter condition that you can customize further. You can select a database column, a filter operator, and a value to filter by. You can also apply "and" or "or" logic to the conditions to determine how these are conditions are joined together.
You can create complex conditions with "and"/"or" operators. For example, Task Status is equal to Done and Due Date is Today.
To add sorting, click on "+ Add Sorting". This will add a default sort that you can customize further with the fields/columns to sort by. You can select the order, either ascending (A → Z) or descending (Z → A), for each field.
Keep in mind that during sorting, the first condition would be first used to sort and the second condition would be further used to sort grouped items inside the first sort result.
That's it! Now can you filter or sort your items to view them in a more efficient way.
It's important to note that when filtering items, the items are sent filtered from our servers, and the users only have access to the data visible on the app.