SELECT items.id AS 'Entry ID', items.created_at AS 'Date Submitted', MAX(CASE WHEN meta.field_id = 10 THEN meta.meta_value END) AS 'Full Name', MAX(CASE WHEN meta.field_id = 11 THEN meta.meta_value END) AS 'Email Address', MAX(CASE WHEN meta.field_id = 12 THEN meta.meta_value END) AS 'Product Interest' FROM wp_frm_items items LEFT JOIN wp_frm_item_metas meta ON items.id = meta.item_id WHERE items.form_id = 5 GROUP BY items.id
jQuery(document).ready(function($) $('#formidable-field-category').change(function() var category = $(this).val(); $('#wpdatatable-1').DataTable().ajax.url( ajaxurl + '?action=get_filtered_data&cat=' + category ).load(); ); ); -EXCLUSIVE- Formidable Forms integration for wpDataTables
Have you tried integrating these two plugins? Let us know in the comments below if you have discovered alternative methods for syncing Formidable Forms data with wpDataTables. SELECT items
This pairing is ideal for any website that manages user-submitted data: The integration builds a live job board table
Create a “Post a Job” form in Formidable with fields like title, description, salary, and department. The integration builds a live job board table on your careers page. When a user submits a job, it appears in the table within seconds—no admin approval needed (or approval can be added via a checkbox in Formidable).