Does anybody know how I can dictate the sort order in a Lookup field? I have a table of companies that can be added to over time, thus will not necessarily be entered in alphabetic order. Of course I can sort the actual table itself, but if I try to perform a lookup from this table, the presentatio…

Hi @David_Clegg , This post could be of your interest: [image] Combine Sort() statements in one formula? It’s possible to combine Sort() statements using the Table UI, and to rearrange them to change sort priority. (see embedded View example) Is it also possible to comb…

Not sure this helps - this appears to be related to sorting a table, which is great, but not sorting the presented list derived ‘from’ a table when used for during a Lookup - unless I’m missing something!

@David_Clegg [image] David_Clegg: this appears to be related to sorting a table, which is great, but not sorting the presented list derived ‘from’ a table when used for during a Lookup The use case was exactly this, and thanks to @Dalmo_Mendonca , I implemented it yesterday. (The forum post q…

Thanks for this - will experiment again soon. I’ve been under the misguided apprehension that Lookups provided a reference to the source data, whilst Select Lists were a copy of the source data, thus I’d lose any true referential integrity, but that appears not to be the case!

Sort order in a Lookup

Jean_Pierre_Traets March 19, 2019, 11:44am 2

Hi @David_Clegg,

This post could be of your interest:

Kind regards,
//JP

Topic		Replies	Views
Dropdown Columns via a Lookup - How to change the order?	8	2728	March 2, 2021
Sort Table by Table Order of Lookup Column Product Feedback	1	724	January 24, 2024
How to sort Select Items?	1	1682	April 11, 2021
Combine Sort() statements in one formula?	3	2059	September 12, 2019
Use a button to st	3	1288	March 19, 2021

Sort order in a Lookup

Related topics