Oct 08, 2020 03:33 PM
Is there a way to definitively define the sort order when linking to an existing record on a “Link to another record” field type?
Let’s say we have “Table 1 (T1)” and “Table 2 (T2)”. On T2, I’ve created a linked record to T1. I’ve created a view on T1 with the appropriate sorting order (in this case, “date modified”). On T2, I’ve selected this view on the “Limit record selection to a view” setting. When I go to associate / start entering my query and filtering records from T2, it seems the order is not predictable, and certainly, not sorted by the “date modified” as I had defined in the T1 view.
Any ideas how to maintain sort order from the T1’s view?
Oct 08, 2020 08:22 PM
As long as your records in the T1 view are not grouped, then your records from that view will be sorted in the exact same order when you go to add those linked records in T2.
But if you group your records, then Airtable strangely has no concept of the sort order anymore. It’s very bizarre.
Oct 10, 2020 08:00 AM
As long as your records in the T1 view are not grouped, then your records from that view will be sorted in the exact same order when you go to add those linked records in T2.
But if you group your records, then Airtable strangely has no concept of the sort order anymore. It’s very bizarre.
The records in T1 are not explicitly grouped, but the sort order is defined first by a formula (returning a boolean), then by date modified. Perhaps it’s treating this computed property as a “grouping”?
Oct 10, 2020 08:22 AM
Nope, that won’t make a difference. If you’re still having problems, post a video with the issue that you’re having.
Oct 10, 2020 03:04 PM
Nope, that won’t make a difference. If you’re still having problems, post a video with the issue that you’re having.
Is there something I can show you specifically / describe to help isolate the issue? I am expecting linking a record from T2 to show the same sort order as if I was using the filter function on T1 on the primary key. Assuming View 1 (V1) exists on T1.
On T1 and on V1, I filtered my records with query “XYZ” and observed the results/sort order.
After clearing the filter on T1, on T2, I proceeded to start to link a record from T1 (with “limiting record selection” set to V1), entered the query “XYZ” and observed the results/sort order, the results appeared in a different order after comparing.