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 #3386293
integrating database tables with forign keys
Closed

Comments

  • Russell Kozik started the conversation

    I'm new to developing and WordPress, Is the following example doable with Wpdatatable Pro and the Forminator addon? Any advice would be greatly appreciated. I am trying to use Forminator forms with the Forminator addon to capture information from two-sides of a niche marketplace, supplier and end-user. Each end-user will find suppliers that have the product/s that the end-user is looking for in a specific area/region. I created 3 table from Forminator Forms supplier, end-user, order information/Product ( 1-15 products possible , can be 1 or more per order). Do I need to make a separate table for the 15 products? I also need a seperate table for zipcodes. I hope to use WPgoMaps plugin and search in radius feature  for zipcodes. Thank you.

  •  1,894
    Miloš replied

    Hi, Russell.

    Sorry to disappoint you, but when you create a table in our Plugin which is pulling data from a Forminator Form,

    this is not making a new table in the SQL Database.

    • These kind of datatables are not saved in the database like manual tables, 

    but instead, their data is stored in database table wp_wpdatatables_rows in JSON format. 

    So, pulling this data from the database through our SQL based tables is very complex because this database table stores data in JSON format, not like manual tables (columns * rows).

    The difficulty level is higher than usual because this kind of data is stored in the database as serialized JSON format,

    so a certain level of SQL skill is needed to make a custom Query.

    Please be advised that writing custom SQL Queries or debugging custom Queries does not fall under what our support covers.

    -


    2. Our Foreign Key Relation :

    The only way to use our Foreign Key Relations feature is with SQL Query Based tables and Manual Tables.

    Please check more about this with an example here.

    https://wpdatatables.com/documentation/front-end-editing/configuring-table-relations-foreign-key/

    Let us know if you nave any questions.

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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