How to Reorder Records in Airtable Grid View
Reordering records in Airtable’s grid view is straightforward, until you run into the situations where it stops working. Here is everything you need to know about manual record order, when you can use it, and how to keep a persistent custom order even when sorting is applied.
Dragging Records to Reorder Them
When no sort is applied to your grid view, you can reorder records by dragging them.
Hover over a record in the grid. A small drag handle (six dots) appears on the left side of the row. Click and hold the handle, drag the record to the position you want, and release. The record snaps into place.
This works for single records, and you can move them anywhere in the table, to the top, bottom, or between any two existing records.
Why Dragging Stops Working When You Sort
The drag handle disappears and record reordering is disabled whenever an active sort is applied to the view.
When a sort is active, Airtable maintains your records in the sorted order and any manual drag would immediately conflict with that sort. Airtable resolves this by disabling dragging entirely rather than allowing a state where your manual order and the sort order fight each other.
To re-enable dragging, remove the sort from the view. Click the Sort button in the toolbar, then remove all active sort conditions. Once the sort is cleared, the drag handles return.
This also means that if you carefully arrange records manually and then apply a sort, your manual arrangement is overridden. The sort takes precedence.
How to Keep a Persistent Custom Order
If you need a stable, sortable custom ordering that survives across different views and sessions, the reliable approach is to use a number field as an explicit order field.
How to set it up:
-
Add a new field to your table and name it Order or Position. Set the type to Number.
-
Assign a number to each record, such as 10, 20, 30, 40, and so on. Using multiples of 10 gives you room to insert new records between existing ones. For example, you can insert a record at 15 without renumbering everything.
-
Apply a sort in your view: sort by the Order field, ascending.
Now your records appear in your custom sequence regardless of when they were created or how the data was entered. To reorder records, update the number. For example, changing 30 to 25 moves a record above what was previously at 30. To insert a new record between existing ones, assign it a number between the two surrounding records.
This approach works in any view type (grid, calendar, gallery, kanban) because it is based on a field value, not a positional drag.
Reordering in Other View Types
Gallery and Kanban views support drag-and-drop reordering within a group, similar to grid view, when no sort is active.
Calendar view positions records based on their date field. The date is what determines where a record appears, so manual reordering of individual dates is not possible. If you need to change a record’s position on the calendar, update the value in its date field.
Timeline view works the same way as Calendar view. Records are positioned based on their start and end date fields.
Form view does not show records at all. It is designed purely for data entry.
For controlling the order of options in a single-select or multi-select field (rather than records), that is managed separately in the field settings. Click the field name to edit it, then drag the options to reorder them.
Reordering Records Within a Group
When records are grouped in a grid view, drag-and-drop reordering works within each group independently. You can move a record up or down within its group, but you cannot drag a record from one group into another - changing groups requires editing the value of the grouped field directly.
For more on grouping and sorting, see How to See and Manage User Permissions in Airtable if you need to restrict who can change record order, or How to Refer to a Cell in a Previous Row in Airtable if you need to create formula fields that depend on record position.