Ability to automatically sort linked records

[ScottWorld]

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! 🙂

[ScottWorld]

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]

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]

I am looking for this solution too.

[Hannah_Martin]

+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]

Highly looking for this feature too :confused: