Hi, first I'm new to WP, am using Elementor pro, Lenix Elementor Leads addon and wpDataTables.
I am trying to extract information from a submitted form into a wpDataTable. However whilst I finally found the form data it is on a long text field containing all the fields. It was in wp_postmeta.
My question is how do I deconstruct this to yield each, or selected, form elements as a separate column in wpDataTables. It must be possible as when I open Lenix the form elements are there as separate columns.
I was using the query builder in wpDataTables and what I ended with was that it picked up the long-text item but I could find no way of separating out the individual meta-data items into individual wpDT columns. Sorry I may not have said that in the original question.
Hi micornelius, Unfortunately, then you have to write custom MySQL query to return those data like you need. Every form builder plugin have specific method for saving data in database and you have to adjust query to return data from database. At the moment we don't have integration with form builder that you are using. You can take a look in our documentation about integration with form builders and wpdatatables: about Gravity Forms integration for wpDataTablesand Formidable Forms Integration: Integrating with the WordPress form plugin.
Please note that standard item support (as defined by Envato's definition of support) does not include writing MySQL queries.
Hi, first I'm new to WP, am using Elementor pro, Lenix Elementor Leads addon and wpDataTables.
I am trying to extract information from a submitted form into a wpDataTable. However whilst I finally found the form data it is on a long text field containing all the fields. It was in wp_postmeta.
My question is how do I deconstruct this to yield each, or selected, form elements as a separate column in wpDataTables. It must be possible as when I open Lenix the form elements are there as separate columns.
Thanks
Michael
Hi Michael,
Thank you for your purchase.
My suggestion is to look up in our documentation about Create a MySQL-query-based table by generating a query to WordPress database.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan
Thanks for your reply
I was using the query builder in wpDataTables and what I ended with was that it picked up the long-text item but I could find no way of separating out the individual meta-data items into individual wpDT columns. Sorry I may not have said that in the original question.
Thanks
Michael
Hi micornelius,
Unfortunately, then you have to write custom MySQL query to return those data like you need. Every form builder plugin have specific method for saving data in database and you have to adjust query to return data from database. At the moment we don't have integration with form builder that you are using. You can take a look in our documentation about integration with form builders and wpdatatables: about Gravity Forms integration for wpDataTablesand Formidable Forms Integration: Integrating with the WordPress form plugin.
Please note that standard item support (as defined by Envato's definition of support) does not include writing MySQL queries.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables