lookup field too long

The recommended method of customizing your AppGini-generated application is through hooks. But sometimes you might need to add functionality not accessible through hooks. You can discuss this here.
Post Reply
theyland
Posts: 12
Joined: 2020-11-04 15:43

lookup field too long

Post by theyland » 2022-12-09 15:23

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

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: lookup field too long

Post by jsetzer » 2022-12-09 15:44

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.
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

theyland
Posts: 12
Joined: 2020-11-04 15:43

Re: lookup field too long

Post by theyland » 2022-12-09 16:04

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????

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: lookup field too long

Post by jsetzer » 2022-12-09 16:08

Glad, I could help ☺️
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

Post Reply