Just discovered this myself. It’s definitely odd behavior. I needed to grab the first linked item in a field via a function, and was confused why LEFT() wasn’t getting me what I wanted.
Don’t know if it’s possible to change this, but it certainly should be documented. Array order does matter sometimes.
This seems really weird behavior! We use Airtable as the basis for producing documents, and users link sections into a list on Airtable. It makes intuitive sense that the topmost item would appear first in the API response (and also the document!)
Would make sense if order was reversed. Workaround is that we’ll do an array reverse in our system.
If this ever is fixed, I guess would be good to have new API version as would break existing apps using API…
Tom
Just found that it relevant not to API only, but if you try to perform a formula on a linked field, it will appear opposite:
e.g. link field has following values: 1,2,3,4,5
the column with formula that simply references to the link field will show 5,4,3,2,1
This old quirk is being phased out. This article on
reordering record links has more info.
Just found that it relevant not to API only, but if you try to perform a formula on a linked field, it will appear opposite:
e.g. link field has following values: 1,2,3,4,5
the column with formula that simply references to the link field will show 5,4,3,2,1
You have the option to reverse the order of a linked field now - at list on the pro version - natural order of Airtable is last left and first right. Now when you link fields you can chose to have first left last right.
You have the option to reverse the order of a linked field now - at list on the pro version - natural order of Airtable is last left and first right. Now when you link fields you can chose to have first left last right.
wow thanks! works perfect!
