Skip to content

Formidable Flat API v3.2.1

Choose a tag to compare

View all tags
@vincentrathbone-web vincentrathbone-web released this 26 Aug 22:40
· 8 commits to master since this release
v3.2.1
6542cbe

Join type control: left / inner / right / full outer

Query-to-query joins (the "1b Join other saved queries" step) always kept every unmatched row from your own query and had no way to ask for anything else. There's now a "keeping" dropdown next to each join's match-mode picker:

  • all of mine (left) — default, same behavior as before. Every row from your query is kept, matched or not.
  • only matched rows (inner) — drops a row that found nothing on the other side.
  • all of theirs (right) — the mirror image of left: drops your unmatched rows, and adds rows that exist only in the joined query instead.
  • everything (full outer) — keeps both kinds of unmatched row.

The row-count banner under each join now shows live matched / no-match counts for every join (previously this only worked for "nearest before" joins), plus a "+N theirs-only" count when a right/full join pulls in joined-only rows — so a key mismatch between two queries is visible immediately instead of discovered later in an export.

Joins-only queries — no source table required

A saved query can now be built entirely from step 1b, with no Formidable table in step 1 at all. Useful when what you actually need is two existing saved queries combined, and neither one maps cleanly to a single form.

The first join row now reads "start from this saved query" instead of asking for a match key — it supplies the starting rows. Any join added after that works exactly as normal, matching against the accumulated result, and its "match my" dropdown correctly offers the first query's own output fields (previously this dropdown had nothing to offer at all with no source table selected).

Fixed

Saving a joins-only query silently dropped its base-supplying first join — it would preview correctly, then come back broken after a reload, because the save-time sanitizer required a match key on every join unconditionally. Fixed in both the normal save path and the legacy no-JS fallback.

Install

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

Assets 3
Loading