I need to know will I be able to link tables for editing? Here is a use case example:
User clicks on add new invoice. In the new invoice, a client is selected using a dropdown that is pulling data from the customers table. The user realizes that the customers phone number has changed, and quickly want to edit the customer but not leave the new invoice form to do so.
Will I be able to edit the customer (data from another table) and then continue to create the invoice, like in the example case? Its almost like a quick edit feature to update relational data before continuing.
Above is an example from Zoho invoice. This is very similar your new master detail addon, except that it needs to be able to edit the data as well.
Thank you for your interest in our plugin, but I don't believe you'll be able to achieve this.
Like you said - Master-Detail brings up a read-only modal (or page), and it can't be editable.
If you were to use our regular "New Entry" modal, each column's new entry would have to be configured as a foreign key, meaning you wouldn't be able to simply choose the customer's name, and have all the fields populate automatically. So, if User1 has Name1, Lastname1, Phone1, Address1, there's nothing preventing whoever is adding the new invoice from selecting User1, Name2, Lastname3, Phone4, Address5...
I'm not sure if i am explaining it correctly. What I meant is, to be able to open one table from within another table - let's try another example. I'm on the invoice table, and need to edit the product details like description, then I would simply click edit next to the product number, and edit the product details (from products table) in a popup. So even though the products are pulled from the products table and used in a select dropdown in the invoice table, I would be able to click edit, and would be shown a edit popup of the product, above the already open invoice popup. Basically modal popups that stack over one another?
In one sentence I need to be able to edit data from a relation table, from within another table. Open table A, choose option from table B AND have the ability to quickly edit data from table B WITOUT leaving table A.
That makes sense, Andre, but it's not possible with the plugin's built-in features.
You cannot edit data coming from another table in the table (foreign key feature - I assume?).
You can create the product number as a hyperlink, so when you click on it, it takes you to the other table, but opening the popup and editing it right away is not possible.
If every product is a cell of a column, you would be able to create an SQL Query based table where you would CONCAT the anchor tag around the column's values.
For example:
SELECT column1, column2, column3,
CONCAT('<a href="www.yourwebsite.com/product',yourTable.productColumn,'/">',yourTable.productColumn,'</a>') AS hyperlink
FROM yourTable
Another way would be with a custom function, but all this is considered custom work, so we wouldn't be able to help you out with it.
HI
I need to know will I be able to link tables for editing? Here is a use case example:
User clicks on add new invoice. In the new invoice, a client is selected using a dropdown that is pulling data from the customers table. The user realizes that the customers phone number has changed, and quickly want to edit the customer but not leave the new invoice form to do so.
Will I be able to edit the customer (data from another table) and then continue to create the invoice, like in the example case? Its almost like a quick edit feature to update relational data before continuing.
Above is an example from Zoho invoice. This is very similar your new master detail addon, except that it needs to be able to edit the data as well.
Thanks
Hello Andre
Thank you for your interest in our plugin, but I don't believe you'll be able to achieve this.
Like you said - Master-Detail brings up a read-only modal (or page), and it can't be editable.
If you were to use our regular "New Entry" modal, each column's new entry would have to be configured as a foreign key, meaning you wouldn't be able to simply choose the customer's name, and have all the fields populate automatically. So, if User1 has Name1, Lastname1, Phone1, Address1, there's nothing preventing whoever is adding the new invoice from selecting User1, Name2, Lastname3, Phone4, Address5...
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
Hi
I'm not sure if i am explaining it correctly. What I meant is, to be able to open one table from within another table - let's try another example. I'm on the invoice table, and need to edit the product details like description, then I would simply click edit next to the product number, and edit the product details (from products table) in a popup. So even though the products are pulled from the products table and used in a select dropdown in the invoice table, I would be able to click edit, and would be shown a edit popup of the product, above the already open invoice popup. Basically modal popups that stack over one another?
In one sentence I need to be able to edit data from a relation table, from within another table. Open table A, choose option from table B AND have the ability to quickly edit data from table B WITOUT leaving table A.
Hope this makes sense.
Thanks
That makes sense, Andre, but it's not possible with the plugin's built-in features.
You cannot edit data coming from another table in the table (foreign key feature - I assume?).
You can create the product number as a hyperlink, so when you click on it, it takes you to the other table, but opening the popup and editing it right away is not possible.
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
Thanks, how would I achieve this programmatically for each product?
Hello again Andre
If every product is a cell of a column, you would be able to create an SQL Query based table where you would CONCAT the anchor tag around the column's values.
For example:
SELECT column1, column2, column3, CONCAT('<a href="www.yourwebsite.com/product',yourTable.productColumn,'/">',yourTable.productColumn,'</a>') AS hyperlink FROM yourTableAnother way would be with a custom function, but all this is considered custom work, so we wouldn't be able to help you out with it.
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