I am trying to figure out if this plugin will work for my needs. I have a data table that I want users to edit the fields, driven by a Mysql query.. so the user would click to edit the row and up would show a dropdown or select box with ID/value pair. They can edit the field inline and it would update the row with the new ID in the database.
I am trying to figure out if this plugin will work for my needs. I have a data table that I want users to edit the fields, driven by a Mysql query.. so the user would click to edit the row and up would show a dropdown or select box with ID/value pair. They can edit the field inline and it would update the row with the new ID in the database.
Hi Craig,
Thank you for your inquire.
We do have editable tables created from MySQL query - Documentation
and you can configure it to have dropdown as editor input type - Documentation
If you need to show one information in column and other to be saved you can take a look at foreign key option - Documentation
For testing purpose we have sandbox website where you can see and test all plugin functionalities
sandbox.wpdatatables.com
username: demo
password: demo