Record Sort Order Options

Modified on Fri, 23 Oct at 3:30 AM

IntelligenceBank offers different sorting options for records within databases. The default options available are:

  • Date Created - by most recent to oldest
  • Last Updated - by most recent to oldest
  • Alphabetical - by record title name 0-Z
Note: If you sort by alphabetical order, our search will prioritise records with title names that begin with the following:
  1. Special Characters, i.e. '*!?$#' etc.
  2. Numbers
  3. Letters

Setting the Default Record Sort Order in a Database

The default record sort order can be set on a database level by:

  • Main Admins
  • Database Admins
  • Users with Manage permission on Databases

To set this up:

1Open Database SettingsNavigate to the relevant database. Select the three vertical dots in the top right-hand corner and select Database Settings. This can also be set when creating a new database.Database Settings option in the database menu
2Choose the default orderLocate the Default Order field. Click into the dropdown to select which default order you'd like. Note that if your default layout is Calendar view, you won't be able to select a default order.Default Order dropdown in Database Settings
3Save your changesOnce you've made your selections, scroll to the bottom of the page and select Save. The default order of records in that database will display for users moving forward.

Additional Record Sorting Options

Users may be able to sort records by options other than the default ones outlined above.

If the database form includes a sequence ID field, users can also sort records by sequence ID (ascending or descending). Note, however, that this cannot be set as a default sort option.

If the records are displayed in a Kanban layout, Admin users will be able to manually/custom sort or re-order records within swim lanes by priority as well. To learn more about how to do this, please reference this article.

Viewing Records in a Different Sort Order

Individual users can choose to view records in a different sort order within databases or from a search by following the below steps:

1Navigate to the databaseNavigate to and click into the database you'd like to view records in.
2Select the Sort iconSelect the Sort icon illustrated below. A green check mark will appear next to whichever is the current/default sort order the records are displayed in.Sort icon showing the current sort order
3Choose a new sort orderTo update the sort order, select one of the other options. The records will update their sort order immediately.Choosing a new sort order
Note: If users are performing a records search, the records will sort by relevance by default (most relevant to least). Users will be able to adjust the sort order from a search by following steps 2-3 outlined above. For more information about how search works, please refer to this article.
Note: Within each sort option, users can also choose to sort records in the opposite order (i.e. if sorting records alphabetically, users can choose to sort records Z-0, versus 0-Z).
Important: Individual users cannot set their own default sort order for records; they can only adjust the sort order for the viewing session they're currently in.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article