This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
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! ๐