We have a project for our client with multiple Gravity Forms as referrals and we require the ability to pull in multiple form entries into one datatable so thay can be filterable and editable in one place – is this possible with wpDataTables?
I hope so because we were using Gravity Views and this did not acheive this!
I am sorry to disappoint you, but unfortunately what you're trying to achieve is not possible with wpDataTables. You can only create one table from one Form, and combining multiple forms into one table cannot be done.
The table is not being created in the database, but instead pulled from gravity's tables on the fly. Maybe this could be achieved using custom SQL queries, but I've never done that, and cannot say how hard it would be to do that.
Thanks for your reply, I thinking of changing the Gravity Form fields to Custom Post fields and pulling them in that way using wpDatatables WP database queries? Might work!
I have purchased wpDatatables and trying to get my theory to work, but my SQL is not too hot, can you see why I am getting an error on the screenshot attached please? is it because I have spaces in the meta keys from wp_postmeta table?
Please note: this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.
I can only guess at this point, but try to replace the last line with:
AND wp_posts.post_type = 'referral'
If that doesn't work please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Thanks for the help, I have now a solution that works.
I used the Gravity Forms hook - gform_entry_post_save - to capture the entry fields and map them to a manually created SQL wpdatatable, so now all the fields are columns on a row in the same table, filtering and editing just work!
So now, multiple form entries in one table – success!
Hello,
We have a project for our client with multiple Gravity Forms as referrals and we require the ability to pull in multiple form entries into one datatable so thay can be filterable and editable in one place – is this possible with wpDataTables?
I hope so because we were using Gravity Views and this did not acheive this!
regards –– Jamie
Hello Jamie.
Thank you for your interest in our plugin.
I am sorry to disappoint you, but unfortunately what you're trying to achieve is not possible with wpDataTables. You can only create one table from one Form, and combining multiple forms into one table cannot be done.
The table is not being created in the database, but instead pulled from gravity's tables on the fly. Maybe this could be achieved using custom SQL queries, but I've never done that, and cannot say how hard it would be to do that.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Thanks for your reply, I thinking of changing the Gravity Form fields to Custom Post fields and pulling them in that way using wpDatatables WP database queries? Might work!
If you find the correct data, it must work
Try avoiding CONCAT and JOIN as much as possible, because they can cause filters and search not to work properly.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Hello Aleksandar,
I have purchased wpDatatables and trying to get my theory to work, but my SQL is not too hot, can you see why I am getting an error on the screenshot attached please? is it because I have spaces in the meta keys from wp_postmeta table?
Any help appreciated please?
Jamie
Hi again Jamie.
Please note: this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.
I can only guess at this point, but try to replace the last line with:
If that doesn't work please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Hi Aleksandar,
Thanks for the help, I have now a solution that works.
I used the Gravity Forms hook - gform_entry_post_save - to capture the entry fields and map them to a manually created SQL wpdatatable, so now all the fields are columns on a row in the same table, filtering and editing just work!
So now, multiple form entries in one table – success!
regards,
Jamie
Great work, Jamie!
Thanks for letting me know, it's a great work around.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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