: In the wpDataTables creation wizard, choose “Formidable Forms” from the data source dropdown. You will then see a list of all published forms on your site.
Displaying "Job Application" form entries in a clean, searchable list for hiring managers.
The integration is built on a direct API handshake between the two plugins. When you install and activate both plugins (with compatible versions), a new data source option appears in wpDataTables called -EXCLUSIVE- Formidable Forms integration for wpDataTables
Before we look at the "how," we must understand the "why." Both plugins are powerful alone, but together, they solve a critical WordPress problem:
Ensure you have the core wpDataTables and Formidable Forms plugins installed and activated. : In the wpDataTables creation wizard, choose “Formidable
Formidable allows repeating fields. These are stored as serialized arrays in the database. wpDataTables cannot display serialized arrays as plain text in a standard column.
Formidable forms act as stock intake or sales records. The table aggregates quantities, alerts low-stock items via wpDataTables’ conditional formatting (e.g., turning a cell red when stock < 5), and even supports editing of stock levels directly from the table. The integration is built on a direct API
Formidable Forms integration - wpDataTables Tables and Charts Plugin
Let’s assume you have Formidable Forms Pro and wpDataTables (v4.0 or higher) installed.
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