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.
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.
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.
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.
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 | 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