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!

Okay
  Public Ticket #2892883
2 Tables: Pulling Name from Table 2, Editing Table 1, ID.
Closed

Comments

  • Frank started the conversation
    October 12, 2021 at 1:16pm

    If i were just doing this in PHP/MySQL it would be easy, but I do not seem to understand how (if?) wpDataTable can do this.  You've tried to help, but I'm just not getting it.  I've therefore being editing this manually. I've been told it needs to work, or we need a new solution.

    Here is the front table display: cX9JWQB.png


    This display pulls from 2 tables, and displays Table 1.

    Table 1 has id, from_date, to_date, empnum
    Table 2 has id, empnum, fullname, ... (a lot of employee info)

    We join tables on empnum and display the fullname name on our table above.

    VcdADWp.png

    However, this is an oncall table, so now and then employees swap weeks.

    On the front end, I need to be able to edit the table, get a drop down off all the "Employees" and select a new person... 

    z62sTtk.png

    The fullname needs to show, but the empnum needs to be the value so that this updates the empnum in table 1, and on refresh pulls the new fullname from Table 2.

    I'm sadly just not making the connection in the interface.

  • [deleted] replied
    October 14, 2021 at 1:35pm

    Hi Frank

    Thank you for reaching out to us.

    Editing is tricky with joined tables. Can you please send us the dump of these two tables from the database, so we can test them locally?