⌛Filtering, Sorting, or Grouping Items

Filtering, sorting, and grouping 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.

Sorting helps users arrange items in a specific order.

Grouping helps users visually segregate the items based on a particular property.

Grouping is only available on List Screens (View Items/Update Items).

This is different from Notion databases filtering, sorting, or grouping because you can create multiple apps with different filters, sorts, or groups and provide it to different 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", "+ Add Grouping" to add filtering or sorting.

Filtering

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.

Sorting

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.

Grouping

To add grouping, click on "+ Add Grouping". This will add a default group that you can customize further with the column/property to sort by. You can select the sort order, either ascending (A → Z) or descending (Z → A) for the grouping property.

Currently only one property can be used to group items.

Sorting and grouping work well together. The grouping takes priority and inside the groups, the items are sorted based on your sorting order.