Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Ability to automatically sort linked records

cancel
Showing results for 
Search instead for 
Did you mean: 
ScottWorld
18 - Pluto
18 - Pluto

We really would love the ability to AUTOMATICALLY sort the related list of linked records.

We know that we can MANUALLY sort the related list of linked records, but we would love the ability to AUTOMATICALLY sort.

Oh, and equally important, we’re not just looking for the ability to automatically sort linked records alphabetically. We’re looking for the ability to automatically sort linked records by ANY value in their respective table.

So, for example:

I am creating a large travel itinerary for a tour company where my main table is “Countries” and my secondary table is “Cities”.

I have linked each “country” record in the “Country” table to multiple different “cities” in the “Cities” table.

But each “city” record has a start date & an end date, so there is a natural ordering to the cities. The cities can be ordered chronologically by date. In fact, that is the VERY BEST way for cities to be ordered: chronologically by date.

Back in the “Country” table, each “country” record is linked to multiple “cities” from the “Cities” table.

However, on each “Country” record, Airtable has listed all the “linked cities” in some random order. It seems like Airtable has placed them into a “reverse sort order” of when users added each city to its respective country. But this is of no value to us.

We would like the “linked cities” to be listed chronologically by date for each “country”.

Other database languages, such as FileMaker Pro, have this ability (to automatically sort linked records) natively baked into the program. It would be amazing if Airtable had this same feature! 🙂

Thanks! 🙂

15 Comments
ScottWorld
18 - Pluto
18 - Pluto

Please be sure to email support@airtable.com with this important feature request! They don’t typically see what we write here, so it’s important to email them. :slightly_smiling_face:

kuovonne
18 - Pluto
18 - Pluto

My app for sorting linked records by any field in the linked table is currently in review with Airtable. I also have an automation script for keeping linked records sorted.

D_W
5 - Automation Enthusiast
5 - Automation Enthusiast

I am looking for this solution too.

Hannah_Martin
5 - Automation Enthusiast
5 - Automation Enthusiast

+1. This would be really great. I’d also love to pick which field to sort by, since the Batch Update extension doesn’t have that feature.

Nils_Cambreleng
4 - Data Explorer
4 - Data Explorer

Highly looking for this feature too :confused: