"Automatically get value from 2nd table" (#1943836) / TMS-Plugins

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!

Public Ticket #1943836

Automatically get value from 2nd table

Closed

Comments

Giang Lê Hoàng started the conversation
March 22, 2019 at 4:56am
Hi,

I have 2 tables:

Table 1 = There are two columns: Name - Contact Phone (Photo 1)
Table 2= Another table (Photo 2) with many column, 2 of them are Name - Contact Phone

Now, I want every time create a new row in Table 2, after select column Name = Doãn Quốc Huy, the column Contact Phone automatically get value = 082.222.2424 as in Table 1 without inputing.

Can we do that with wpDatables? if not can you guide me direction for extra coding...

Thank you!
2,576
Aleksandar replied
March 22, 2019 at 11:33am
Hello Giang Lê Hoàng.
Thank you for your purchase.
This can be achieved using Foreign Keys. Please note, though, that the first table should have a unique auto-increment ID column, so each user has its own ID to which the foreign key will be linked.
Please feel free to download the templates and recreate the example table from the documentation in the link above to get the look and feel of how a Foreign Key table works.
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