I would like to know if it is possible to connect data from one table with another table withing this plugin and / or any add-ons. To clearefy see following situation:
TABLE 1. This table is for adding / changing / removing contact information of various mechanics. This one should contain the persons data such as name, phone number, address and company name of the mechanic. This table needs to be searchable.
TABLE 2. This table is for adding / changing / removing project work logs. This one should contain information such as date, time, location and discription. But also the name of the mechanic that worked on this project.
Is it possible to add 'John Doe' as a mechanic to TABLE 1 (with all his contact information) and then add a work log to TABLE 2 and then select 'John Doe' has worked on this project?
Hi there,
I would like to know if it is possible to connect data from one table with another table withing this plugin and / or any add-ons. To clearefy see following situation:
TABLE 1. This table is for adding / changing / removing contact information of various mechanics. This one should contain the persons data such as name, phone number, address and company name of the mechanic. This table needs to be searchable.
TABLE 2. This table is for adding / changing / removing project work logs. This one should contain information such as date, time, location and discription. But also the name of the mechanic that worked on this project.
Is it possible to add 'John Doe' as a mechanic to TABLE 1 (with all his contact information) and then add a work log to TABLE 2 and then select 'John Doe' has worked on this project?
---
I think I found this option here https://wpdatatables.com/documentation/front-end-editing/configuring-table-relations-foreign-key/.
Additional: Is it possible to make the employee (mechanic) name clickable in TABLE 2 so the employees contact details are popping up?
Hi Jaro,
Thank you for your interest in wpdatatables.
Yes if I understand you right you can use foreign keys in TABLE 2.
Unfortunately creating link form employee and show details is not possible.
What we have is to show More details about data from table row with our add-on Master details.
You can check out more on this link https://wpdatatables.com/documentation/addons/master-detail-tables/
Also, you can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin premium features.
You can try wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters |
Master-detail
Gravity Forms Integration for wpDataTables |
Formidable Forms Integration for wpDataTables
All useful information about all wpdatatables features that are explained (video and text) you can find in our DOCUMENTATION.
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