Help

Sorting table by date

Topic Labels: Views
467 3
cancel
Showing results for 
Search instead for 
Did you mean: 
jeffyauu
4 - Data Explorer
4 - Data Explorer

Hello, I have a Airtable Table that sorts different records by release date. I want to be able to manually re-order the different records that have the same release date (as many of them do) but for some reason I can't figure out how to do that? I've tried to turn off automatic sorting and then manually re-arrange my records but as soon as I turn automatic sorting back on, it overwrites my changes. Anybody got a fix or insight for this?

3 Replies 3
Saravanan_009
8 - Airtable Astronomer
8 - Airtable Astronomer

To manually re-order records that have the same release date in Airtable while maintaining the automatic sorting for other records, you can use the following approach:

Create an additional field: Add a new field called something like "Order" or "Sort Priority." This can be a number or text field.

Manually set the order: For records with the same release date, assign a unique value in this "Order" field based on the order you want them to appear.

Adjust your sorting: Modify your existing sort criteria to first sort by the release date, and then by the "Order" field.

This method allows you to manually control the order of records that share the same release date while keeping automatic sorting for other records intact.

DisraeliGears01
6 - Interface Innovator
6 - Interface Innovator

Another hacky solution would be to simply turn on time for your date field and then assign records minutes to maintain your ordering.

The Kanban Interface view also allows you to create a sort order via drag and drop too: https://community.airtable.com/t5/interface-designer/manual-sort-of-cards-in-kanban-element-in-an-in...

If you're just using this visually it should be fine, but note the caveat for this sort order from this thread:
https://community.airtable.com/t5/automations/sort-list-function-not-sorting-the-manual-sort-field-c...