Page 1 of 1

lookup field too long

Posted: 2022-12-09 15:23
by theyland
Hello, I have a DB with the name of over 20000 people. If I create a drop down list, it is simply too long. Is there any way to put a search box instead of a drop down list?
Thanks

Re: lookup field too long

Posted: 2022-12-09 15:44
by jsetzer
Hmmm, usually there is a search field right inside the lookup dropdown (select2 lobrary) as soon as we have more than 5 (I think) entries.

Did you configure that field as lookup?

Just an idea:
I know select2 has an option for minimum characters before AJAX request starts. Maybe we should figure out how to increase that minimum value to 5 or so, which should dramatically reduce responded data from server to client. Benefit: you can still use all existing lookup functionality and don't have to invent and code a custom search algorithm + AJAX data interchange.

Re: lookup field too long

Posted: 2022-12-09 16:04
by theyland
Oh gosh, I am so sorry (and embarrassed now). I was still playing with data.
Of course it's there.
How can I delete my post????

Re: lookup field too long

Posted: 2022-12-09 16:08
by jsetzer
Glad, I could help ☺️