I've created a table with a multi-select box. Upon creation of the row, I can use the multi-select input as expected, however, on editing the multi-select input entry it seems I am only able to select a single item.
EDIT: I've actually found that on recreation of the table, I can't even select multi-select in the first place.. If I chose to predefine the list then it works fine, but if I pull data from another WPDT table I don't get the option for a multi select.
Also, are you able to tell me why the values of the multi-select box (queried from another WPDataTable table) is preloaded and immediately available, whereas another single select box with pre-defined value needs to be queried from the database?
Can you please tell me did you mean for foreign keys columns?
If answer is yes, please note is that editing for columns that are configured as foreign keys is also supported out of the box. The only limitation is that the only possible editor input type for those columns is the single-value selectbox, since the options are limited with respect to what the remote table contains.
Please excuse my ignorance, but I don't really understand why it's not possible to be a able to edit the column with a multiselect. Surely, after the multi-select is made the code will just serialize those values and store them in the table?
The lookup table is just that... a lookup table... I'm not sure why it's a problem, or have I missed something.
Either way, is there a workaround? I was thinking that I could use JS callback to bring up a js form which will serialize selection and paste back to the table DOM (or use ajax to send the data back to the table, and then refresh the table).
I understand that WPDT is largely based on JS Datatables.. therefore, using part of the example in the docs, am I able to access the table DOM using JSDT calls such as:
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
If you are not using foreign keys(with them that is not possible like I explain in previous ticket) please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me on table id where you have this issue so I can take a look.
Like I explain in previous posts you can't use it multi-select edit with columns that are set like foreign keys. What you can do is instead of foreign keys to use in Possible values for column option Define values list on DATA tab in column settings.
When you insert all values that you need and set Editor input type to Multi-value selectbox on EDITING tab in column settings, those values will be available in edit modal like multi-select and you can choose how many you need.
Something like this you can use for all other columns where you are using foreign keys and where you need multi-select edit.
I've created a table with a multi-select box. Upon creation of the row, I can use the multi-select input as expected, however, on editing the multi-select input entry it seems I am only able to select a single item.
EDIT: I've actually found that on recreation of the table, I can't even select multi-select in the first place.. If I chose to predefine the list then it works fine, but if I pull data from another WPDT table I don't get the option for a multi select.
Also, are you able to tell me why the values of the multi-select box (queried from another WPDataTable table) is preloaded and immediately available, whereas another single select box with pre-defined value needs to be queried from the database?
Hi GINO,
Thank you for your purchase.
Can you please tell me did you mean for foreign keys columns?
If answer is yes, please note is that editing for columns that are configured as foreign keys is also supported out of the box. The only limitation is that the only possible editor input type for those columns is the single-value selectbox, since the options are limited with respect to what the remote table contains.
Best regards.
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
Hi Milan, thanks for your answer.
Please excuse my ignorance, but I don't really understand why it's not possible to be a able to edit the column with a multiselect. Surely, after the multi-select is made the code will just serialize those values and store them in the table?
The lookup table is just that... a lookup table... I'm not sure why it's a problem, or have I missed something.
Either way, is there a workaround? I was thinking that I could use JS callback to bring up a js form which will serialize selection and paste back to the table DOM (or use ajax to send the data back to the table, and then refresh the table).
I understand that WPDT is largely based on JS Datatables.. therefore, using part of the example in the docs, am I able to access the table DOM using JSDT calls such as:
jQuery(window).load(function(){ wpDataTables.table_1.addOnDrawCallback( function()
{ jQuery('.column-supplier').click(function()
{ jQuery('#my_checkbox_form').show();
});
(... then use the form to send back to the table etc)
I don't see any documentation to support any such functionality however, so if it is possible do you have an suggestions on how to do it?
My Application really relies on such functionality throughout... so any suggestions would be really appreciated.
Thanks
Hi GINO,
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
If you are not using foreign keys(with them that is not possible like I explain in previous ticket) please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me on table id where you have this issue so I can take a look.
Best regards.
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
Hi GINO,
Like I explain in previous posts you can't use it multi-select edit with columns that are set like foreign keys. What you can do is instead of foreign keys to use in Possible values for column option Define values list on DATA tab in column settings.
When you insert all values that you need and set Editor input type to Multi-value selectbox on EDITING tab in column settings, those values will be available in edit modal like multi-select and you can choose how many you need.
Something like this you can use for all other columns where you are using foreign keys and where you need multi-select edit.
Best regards.
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