Help

Re: Sorting on lookup field that contains single select data behaves unexpectedly

Solved
Jump to Solution
556 1
cancel
Showing results for 
Search instead for 
Did you mean: 
judielaine
5 - Automation Enthusiast
5 - Automation Enthusiast

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
judielaine
5 - Automation Enthusiast
5 - Automation Enthusiast

Turns out working as expected.

See Solution in Thread

2 Replies 2
judielaine
5 - Automation Enthusiast
5 - Automation Enthusiast

Am i right that this is unexpected behavior?

judielaine
5 - Automation Enthusiast
5 - Automation Enthusiast

Turns out working as expected.