Formidable Flat API v3.3.0

Join type for the source-tables merge

Step 1's multi-table merge (2+ Formidable tables joined on a shared key) always behaved as a full outer merge — every row from every table, matched or not — with no way to ask for anything else. There's now a "Keeping" dropdown below the key-field pickers, shown once 2+ tables are added:

• full outer (default, unchanged from before this existed) — every row from every table.
• inner — a key must exist in every table.
• left — every row from the first table.
• right — every row from the last table.

This is separate from the join-type control already on step 1b's query-to-query joins (added in v3.2.1) — that one still works the same way it did.

Fixed: entry status was blank for every normal entry

The Entry Status field (and the legacy Draft Status column) showed a blank value for every normal, fully-submitted entry. The cause: is_draft = 0 — Formidable's own "Submitted" status, and the status the overwhelming majority of real entries have — mapped to an empty string instead of a label, in four separate places in the code. Because drafts are excluded from a query by default, this meant every row that ever reached the status column had status 0, making the field look completely non-functional rather than wrong for one value.

Now shows Submitted / Draft / Abandoned correctly. Any status code the plugin doesn't recognize is shown as its raw number instead of silently going blank, so a future status won't reintroduce this same problem.

Install

Download formidable-flat-api-v3.3.0.zip and install via Plugins → Add New → Upload Plugin. Requires WordPress 5.8+, PHP 7.4+, Formidable Forms 5.0+.