Sort in Base

4 min read
Desktop
Mobile
more
I. Intro
You can sort records based on the conditions you set to organize information in the Base.
II. Steps
  1. Open the base and click Sort at the top.
250px|700px|reset
  1. Select a field to sort and choose the sort method, which includes: A → Z or Z → A, First → Last or Last → First, and 0 → 9 or 9 → 0.
  • First → Last or Last → First: Available for single or multiple options fields. Sort based on first to last or last to first order.
  • A → Z or Z → A: Available for fields that contain text. Sort based on alphabetical or reverse alphabetical order.
  • 0 → 9 or 9 → 0: Available for fields that contain numbers or dates. Sort based on ascending or descending order.
Click the X icon on the right side of the sort condition to delete it. You can also click Save as New View at the bottom of the panel to save the sorted results as a new view.
Note: If records are grouped, sorting will only take effect within each group.
250px|700px|reset
  1. After adding a sort condition, Automatic sorting will be turned on by default and records in the table will be sorted. You can turn off Automatic sorting as needed.
250px|700px|reset
  1. You can add more sort conditions as needed, and data will be sorted based on the order of the sort conditions. Drag the ⋮⋮ icon on the left side of a sort condition to rearrange its order.
250px|700px|reset
  1. Click anywhere in the base to close the sort panel. Two buttons will appear in the view tab: Clear and Save and Sync.
To cancel the sort conditions, click Clear.
If you want other collaborators to see your sort results, click Save and Sync. If you do not click this button, the sort results will only be visible to you and will not be saved. When you refresh the page, the sort results will be reset.
250px|700px|reset
III. FAQs
Who can set, change, or delete sort conditions?
  • When advanced permissions are not turned on, the base owner and users with manage or edit permission, can set, change, and delete sort conditions.
  • When advanced permissions are turned on, the base owner and users with manage permission can set, change, and delete conditions, while users with edit permission can sort based on fields that are within their editable range.
Note: When locked view is turned on, sorting can't be used.
Will sorting in one view affect other views?
No. Sorting is only applied to the current view.
What is the maximum number of sort conditions that can be set?
There is no maximum limit. You can set as many as you need.
How do I adjust the order of columns in kanban view?
You can move the columns left or right and tiles to any position in kanban view to change their order.
250px|700px|reset
Why is there no change in the table after applying sorting?
It may be because there is only one record under a group, which cannot be sorted. For example, in the figure below, Tokyo, Shenzhen, and Singapore under the R&D group only have one record each. No matter what sort conditions are applied, the order of the records in each group will not change.
250px|700px|reset
Written by: Lark Help Center
Updated on 2025-02-06
How satisfied are you with this content?
Thank you for your feedback!
Need more help? Please contact Support.
0
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom