Value list sorting and auto-fill

[Dominic Filteau]

Hi all,

I've been able to keep a field generated list in the order i want by using hints on this post, the thing is that when using the list in another table via a link, (or even in the same table)

the text doesn't auto complete, actually the feature turns off.

basically i'm set this way:

"JobTitle" field

"index"field(to setup the order)number from 01 to XX

"Calculatedindex" field(using

Remplace2 ( 10^index - 1 ; "9" ; " " )

(sorry french application version here)

The list is generated using JobTitle & CalculatedIndex, sorted by 2nd field.

Any idea?

Regards

Dom

[comment]

Help > Editing objects on layouts > Selecting and working with objects on a layout > Setting up a field to auto-complete during data entry:

"Auto-complete is not supported in drop-down lists when the value list used is configured to use Also display values from second field, Show values only from second field, or Sort by second field."

[Dominic Filteau]

Thanks for the reply,

So are you aware of a custom function or a way to keep the "dynamic" list in the order i want but still keep the autofill feature enabled?

I tried a calc field, of the 2 fields used, but they show the spaces in the list.

Maybe i could use the index number and the jobtitle in a calc,to have something like

01-Jobtitle1

02-Jobtitle2

but i'd want to hide the first 3 characters when the list opens, and autofill to work on the first letters (or even better part of a word)for auto filling

[comment]

I don't think it's possible. Perhaps you should explore other possibilities, such as conditional value lists or selecting from a portal/list view.