We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
I try your example
Configuring table relationswith database dummy_employees.sql
When finishing table no button to add column appears (as shown in your example) see screenshot.
I would have to add columns in the new created table
Hello HPPraxis.
Thank you for your purchase.
Adding a new column from the plugin's side is impossible when you're dealing with SQL Query based tables. Those tables are using the SQL tables as an existing data source (just like Excel or CSV), but they can be edited unlike Excel and CSV. You can't, however, add new columns from wpDataTables, only in PHPMyAdmin.
I see what you're talking about, though - in our documentation, when the tables are created from "Employees", "Shippers" and "Customers" the screenshots below are showing the remove and add buttons. But I can confirm that it is not possible to achieve through version 2.0; 2.3.2; 2.4 and 2.5. I can't say that the feature wasn't there when the documentation was written (which can be on a much older version of the plugin), but I seriously doubt that.
A different part of our documentation, which talks about back-end-editor says that the "Add new column" and "Delete column" buttons are specific for manual tables. They cannot be present in the SQL Query based tables.
So, with this in mind - if you would like to add new columns - you can add them in PHPMyAdmin, and they'll be shown in the plugin. Or you can create a new manual table, where you'd need to define every column.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables