Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Sorting on lookup field that contains single select data behaves unexpectedly

Topic Labels: Base design
Solved
Jump to Solution
377 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m finding unexpected behavior when sorting on a single select data lookup field.

In the source table the HT Location is a single lookup field. I have the field values ordered in the “customize field type” control (note Dairy case in in blue before Bakery in green.):
image

In the source table the sort behaves as expected (note Dairy case before Bakery.)
image

The unexpected behavior is in the list table that references the source table. There’s a linked table field, and a lookup on the “HT Locations” field, which is then sorted. Here the order is different, with Bakery coming before Dairy case.
image

I tried making a duplicate of the list table; it duplicated the odd sort behavior. I made a new table, added the same link and lookup fields, and it looked like this table sorts the look up field alphabetically – except for paper supplies – not the order of the look up fields
image

Argh.

Ideas?

1 Solution

Accepted Solutions

Turns out working as expected.

See Solution in Thread

2 Replies 2

Am i right that this is unexpected behavior?

Turns out working as expected.