I have tables for members, boats and docks. I would like to be able to display values from all three tables and enable the user to edit using the appropriate forms for each of the joined tables (not a form with elements of all tables combined). For example, if a user clicks on a member name (or some button/link on the row), the form for editing that member info pops up (or appears in a new page). If they click on a boat name, the form for boats appears. Is this possible?
If not, some suggestions for how it could be enabled: 1) You could enable the Cell Context Prefix and Suffix to support html. Then, I could combine the three elements into a link that would go to the form with the record context. 2) You could add an option to include a link in the column configuration. 3) You could make it so that when a cell is double-clicked it becomes editable and then only the appropriate table is updated. 4) You could expand your calculated field functionality to include string parsing, so that I could parse together an appropriate link.
Option 3 is my preferred approach, but still hoping to hear that it's actually already possible. Fingers crossed.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
To be completely honest, i am not 100% sure about all the points for this type of scenario. I have some ideas how it might work,
but I will have to double-check all the details, to get a second opinion from our senior 2nd level Team; before confirming this for you.
-
Sorry once more for the waiting time, we will do our best to confirm all of the details as quick as possible. I will come back as soon as i get the information.
-
In the meantime, i am not sure if you already tried out using links in our tables; for example either by wrapping them in anchor HTML tags, using multi-line string columns;
My apologies that this took so long to get confirmation, i got the information from the developers.
-
I am sorry to disappoint, but 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.
You can see more information about this functionality here, and the devs made an important note stating these limitations.
Let me know if you have any further questions about this. Thank you
I have tables for members, boats and docks. I would like to be able to display values from all three tables and enable the user to edit using the appropriate forms for each of the joined tables (not a form with elements of all tables combined). For example, if a user clicks on a member name (or some button/link on the row), the form for editing that member info pops up (or appears in a new page). If they click on a boat name, the form for boats appears. Is this possible?
If not, some suggestions for how it could be enabled: 1) You could enable the Cell Context Prefix and Suffix to support html. Then, I could combine the three elements into a link that would go to the form with the record context. 2) You could add an option to include a link in the column configuration. 3) You could make it so that when a cell is double-clicked it becomes editable and then only the appropriate table is updated. 4) You could expand your calculated field functionality to include string parsing, so that I could parse together an appropriate link.
Option 3 is my preferred approach, but still hoping to hear that it's actually already possible. Fingers crossed.
Hi, Thom
Thanks for reaching out to us
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
To be completely honest, i am not 100% sure about all the points for this type of scenario. I have some ideas how it might work,
but I will have to double-check all the details, to get a second opinion from our senior 2nd level Team; before confirming this for you.
-
Sorry once more for the waiting time, we will do our best to confirm all of the details as quick as possible. I will come back as soon as i get the information.
-
In the meantime, i am not sure if you already tried out using links in our tables; for example either by wrapping them in anchor HTML tags, using multi-line string columns;
or by using URL Link type column;
also you can use SQL CONCAT function , maybe it can be useful; we have a video of showing this feature with our plugin here;
-
Thank you for your patience.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi, Thom
My apologies that this took so long to get confirmation, i got the information from the developers.
-
I am sorry to disappoint, but 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.
You can see more information about this functionality here, and the devs made an important note stating these limitations.
Let me know if you have any further questions about this. Thank you
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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