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!