Reordering Link to Another Table column items

Noticed the same thing and did it manually myself as you described. +1 for this to get a look from devs.

We’re working on it! :slightly_smiling_face:

Awesome, thanks for the feedback!

Is it possible for the Airtable employees to be visibly recognizable on these forums? Like a badge or name in a specific color, etc.

Just saw this. Thank you guys very much!

Could the reordering be automatically based to the order in the linked table, or a specific view of that table?

Expand the record and drag and drop them into a different sequence.

That does it for me, but did I misunderstand?

Any update to this? We have an ordered list that gets created then we need use that list in a formula to build the reference name. This doesn’t work properly for us as the formula for the ARRAYJOIN reverses the order of the items in our ordered column. We need the data to be displayed in the order desired otherwise it becomes very confusing for the users/viewers.

Is there a solving that problem?

This is probably a simple solution because what ever order you give to item a,b,c it is always displayed as 3,2,1 therefore the alphanumeric order is just reversed. But it need to be attended and apparently it’s not considered urgent…

Converting a comma-separated list to a Linked Record clearly reverses the order, which is undesirable behavior when order matters.

“Rehabilitation Center, Physical Therapy, Occupational Therapy, Speech Therapy”

clearly becomes

“Speech Therapy, Occupational Therapy, Physical Therapy, Rehabilitation Center”

Interestingly enough, when I copied the linked record field into this message, it reverses it yet again.

I looked throughout the community for a workaround to no avail. Any updates here? Any help is appreciated.

Thanks,
æ

Screen%252520Recording%2525202019-08-09%252520at%25252010.37%252520AM.gif817×507

Converting a comma-separated list to a Linked Record clearly reverses the order, which is undesirable behavior when order matters.

“Rehabilitation Center, Physical Therapy, Occupational Therapy, Speech Therapy”

clearly becomes

“Speech Therapy, Occupational Therapy, Physical Therapy, Rehabilitation Center”

Interestingly enough, when I copied the linked record field into this message, it reverses it yet again.

I looked throughout the community for a workaround to no avail. Any updates here? Any help is appreciated.

Thanks,
æ

Screen%252520Recording%2525202019-08-09%252520at%25252010.37%252520AM.gif817×507

Adam, If you add a lookup field of the “list field” it will reverse the order. In other words it will appears in chronological order. You can then use this lookup field for displaying the correct order; first to last unlike linked field where last link is always displayed first… Good luck.

Hi, has this issue been addressed yet? I’m still seeing the same issues on linked tables. The lookup ‘work around’ doesn’t link to the source data which I’d like to retain. How can this be addressed?

Thanks Ben

Hi @ben_L, have a look at this reply it might help you. Lookup integer sorting order

2020, we need an update on this issue. Array ordering is very important, and the UI suggests order can be retained. However the API just returns the plain reverse order, messing with any system that depends on Airtable.

We need an official backing this up, and documenting this mess. I cannot send editors around now manually reversing every list they have created, if this is clearly a bug and should be fixed on Airtable side.

What is the official stance on this? Please don’t let this die in the useless self-help forums…

Hi Lukas, I don’t think it’s a bug. It is quiet logical to have the last link on top of the list. Now the solution is very easy and you don’t have to manually change the order but instead create a Rollup field that will come in the opposite order of the linked field. Just read my previous post just above yours. we use my solution for printing packing lists and it is the only solution that I’m aware of right now. When I contacted support last year they were not even aware that it could be a problem. Good luck.
BTW a Rollup field always comes into reverse order… I hope they will never fix the rollup order otherwise we’ll be screwed.