dropdown

Questionsdropdown
Gustavo Lazaro asked 7 years ago

Dear, I'm adding a log to a grid. One of the fields is related to another table, which has more than 2000 records. Using dropdown is not practical. How could I do it? Thank you

4 Answers
Abu Ghufran answered 7 years ago

You can try using autocomplete.
It loads data from server only when you type.

refer: demos/integration/autocomplete.php

Gustavo Ageitos answered 7 years ago

Thank you!!!

Gustavo Ageitos answered 7 years ago

Table Client: idClient Int, name Varchar(60)
Table Voucher: idVoucher Int, idClient Int, dateVoucher date, amount decimal(10,2)

How can I save the idClient of the client table in the voucher table using autocomplete.

Abu Ghufran answered 7 years ago

Refer attached demo, related code is at line 77-91 and sql_command query.
https://gist.github.com/gridphp/fb3f4f7ab15dfa0a2cd88532cb8e2e7c

Your Answer

18 + 0 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?