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 #3736491
Two Tables lookup
Closed

Comments

  • David Burley started the conversation
    October 2, 2024 at 9:28am

    I think we are developing our website leaderboard into something beyond the capabilities of wpdatatables but is it possible to have a proper referential lookup between tables ?

    i.e. our leaderboard has rows with a users name and their score but if they do multiple events they cannot click on their name to see all their results, however if we had two tables as follows:-

    Table 1
    userid / name / username / email address /dob columns

    Table 2

    userid / score / venue / date

    then we could do lookups between the two by referencing the userid, is this possible at all with wpdatatables ?

  •  1,895
    Miloš replied
    October 2, 2024 at 10:57am

    Hi David,

    If we understood correctly, the main goal is to create a relation between the tables via a common column ID field - so when Table A row is selected, Table B should load with showing only those filtered rows from the selected row ID of Table A?
    For that use-case, you can use our Master Details feature of Parent > Child table relation.

    If there are multiple possible results in the Child Table, in this case, you can use the 'Send Child Table Data' option via the "GET" method.

     It allows you to display the entire dataset from a child table in a separate table view on a post or page. In this way, you can establish a “One-to-Many” relationship. This means that you can link one row in the parent table to multiple rows in the child table. 


    Please check more details explained on this Documentation with our example tables.

    I hope that helps.

    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