Sorting by a field in Braineet
When you're in a view, you have the ability to arrange your projects in a specific order based on the values in certain fields. Keep in mind that sorting your projects in one view won't affect the order of projects in other views, but only applies to the current view you're using to look at your table.
Getting started with sorting in Braineet views
To configure a new sort:
- Click the Sort option from the view bar.
- Then, pick a field to sort by from the list of fields.
- When sorting by field type, an additional option will be available to choose the order of the sort. For example, in text-based fields, you can sort alphabetically or in reverse alphabetical order, and in date fields, you can choose between earliest to latest or latest to earliest. More information on this can be found in the "Field Types and Sorting" section below.
- Once you've selected the first field to sort by, you can add additional fields to sort by. Just click the Add a field to sort by option.
Once configured you can:
- You can remove any of the sorts you've applied by clicking the X button next to a particular field of your choice.
Field types and sorting
Different field types can be sorted in different ways. Note that in almost all cases, sorting in ascending order will place blank values first.
- You can sort field types such as short text, long text, or formula fields that return text in either alphabetical (A→Z) or reverse-alphabetical (Z→A) order. Braineet uses natural sort order for text, which means that multi-digit numbers in text fields are ordered as single characters. For example, "z2" is sorted before "z11" because 2 is considered smaller than 11. You can also sort attachment fields alphabetically or reverse-alphabetically by the file name.
- When sorting fields that contain numbers, such as number, you can choose to sort them in ascending order (1 → 9) or descending order (9 → 1). Similarly, for fields that contain ratings, you have the option to sort them either in ascending or descending numerical order.
- Date and time fields can use ascending order (1 → 9), which is from the earliest date to the oldest date, or descending order (9 → 1), which is from the oldest date to the earliest date.
- Checkbox fields can be sorted by whether or not the box has been checked, so either (▢ → ✓) or the reverse, (✓ → ▢).
- Single and multiple select fields are sorted according to the text of the option(s) selected.
Automatic and manual view sorting
By default, when you create a new view, it'll have the Apply Automatically toggle turned on.
- If this toggle is turned on, projects will automatically sort themselves if a change occurs to a project that would cause it to be ordered differently according to the sort(s).
- If this toggle is turned off, projects won’t be sort until you click on the apply button.