I'm planning to use wordpress with wpDataTables for my web site.
I have a table with some values in it, there are approx 2000 records. The table has code + description. In another table I'd like to create a foreign key to the first table. I've seen how to do that in your videos and it works great.
However it is a drop down list which with 2k records is a bit painful to use as there is a lot of scrolling. I'm wondering if you have a way to support a 'combobox' type of behaviour. Do you know what I mean? Where you type in a text box and it refines the results from the combo box. So lets say it was countries if you typed FR it would reduce the list to France, French Ghana, etc.
In addition to that but kind of related. If that was possible is it possible to have a field that you can select from a dropdown or combobox but also type you're own value. So lets say there is a list of countries but it doesn't include South Sudan (which is pretty new country), so you can type in South Sudan instead of selecting a value. The list of countries would ideally be in another table. So the relationship isn't a Foreign key but the table of values is used to aid/validate the input.
If you could let me know what you think and if it is possible,
Unfortunately at the moment there’s no built-in solution. However it appears in requests from time to time so we will add to our idea list and look into some possible solutions on plugin side for one of next versions.
Hi,
I'm planning to use wordpress with wpDataTables for my web site.
I have a table with some values in it, there are approx 2000 records. The table has code + description. In another table I'd like to create a foreign key to the first table. I've seen how to do that in your videos and it works great.
However it is a drop down list which with 2k records is a bit painful to use as there is a lot of scrolling. I'm wondering if you have a way to support a 'combobox' type of behaviour. Do you know what I mean? Where you type in a text box and it refines the results from the combo box. So lets say it was countries if you typed FR it would reduce the list to France, French Ghana, etc.
In addition to that but kind of related. If that was possible is it possible to have a field that you can select from a dropdown or combobox but also type you're own value. So lets say there is a list of countries but it doesn't include South Sudan (which is pretty new country), so you can type in South Sudan instead of selecting a value. The list of countries would ideally be in another table. So the relationship isn't a Foreign key but the table of values is used to aid/validate the input.
If you could let me know what you think and if it is possible,
Kind regards
Pete
HI Pete,
Thank you for your purchase.
Unfortunately at the moment there’s no built-in solution. However it appears in requests from time to time so we will add to our idea list and look into some possible solutions on plugin side for one of next versions.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables