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!
Hi I'm looking for 2-3 main options, I have try the sandbox, but not find how to make it if it's possibe.
1. Edit data on linked table ?
Sample : a table with ID, MonitorName, a table with ID, RoomNr, a table like course with ID, Description, IDMonior, IDRoom,. I could build a table on sql query with Course Description, MonitorName, RoomNr. But wenn I try to Edit it, it does not save it in the 3 first table like I esperate.
2. To do It properly of course i need to reduce the imput form on the existing value from Monitor and Room (and have separate table to edit them)
3. If y try to delet a Monitor with ist used in a course (if my DB as a relationship) will it rease an error in your plugin ?
Thanks for your response
Hello Mickael
Thank you for your interest in our plugin.
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
Only one MySQL table can be edited at a time. Queries from multiple tables with joins cannot be used as an editable feature, since SQL UPDATE and INSERT statements are generated automatically, and there currently is no way to update multiple tables.
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
I fast have it with the foreign Key, but my only Problem ist (perhaps an idee for new feature) in the Configure relationship I can only choose one Display value. Like in my DB i have something like
Id / First name / last name / Born year /....
1 / Bob / Dylan /1976 /....
2 / Bob / Doe / 1983 /....
3 / John / Doe / 2010 /....
4 / John / Doe /1941 /....
If I choose the name as display value I will not be able to now if it's one or the other. It will be great to be able to choose more than one display value and add them as virtuelle colone im frontend table.
OR Is their an other way to show in the frontende table some other colone from the remote table linked on to the the selected foreingn key ? Somethink like a view, but without loosing the editing option on main table Feld.
Thanks
I agree with you, that this would be a great feature Mickael, but unfortunately it is not possible.
At the moment, pulling data from other tables is only possible with custom SQL queries, but then there's a chance that editing will not work.
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
Hello, SQL ist not a Problem, I make it in SQL and it work well to make the table (see Picture 1).
But wenn I try to work on the edition I have some trouble. How can I link my concat result as "Foreignkey displayed value" ? And of course how can I make that the "possible value for column" also take it (see Picture 2). I have no Problem writting a SQL statement, but It seem the plugin not alloud it ?
Sorry, Mickael, I don't understand what you're trying to do.
From what I see, you want the "Collaborateur" column from table #10 (SQL) to pull values from table #9 by concating first and last name?
That's not possible.
The only thing you can do is perform the similar CONCAT function in table #9, so the "prenom" column displays both first and last name. After that you should be able to pull the full name into table #10.
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