ARPHost CF7 Submission Archive

Changelog

1.2.2

• Added WordPress.org directory screenshots (settings, submissions list, submission detail) with a readme Screenshots section; CI now syncs the assets/ folder to the WordPress.org SVN assets directory. No functional changes.

1.2.1

• Moved the field-mapping helper script out of an inline <script> tag (admin/class-cf7dbgs-admin.php) into admin/js/cf7dbgs-field-mapping.js, enqueued via wp_enqueue_script() on the Settings page only. No functional change.
• Docs: added the “External services” section describing the Google Sheets API / OAuth2 and Google Apps Script webhook connections, per WordPress.org plugin review feedback.

1.2.0

• Renamed plugin to “ARPHost CF7 Submission Archive” (slug arphost-cf7-submission-archive, text domain to match) per WordPress.org plugin review feedback — the prior name/slug led with the Contact Form 7 (“CF7”) trademark and was too close to other CF7/Sheets integration plugin names. No functional changes. Contributors line corrected to the actual WordPress.org account (hostalot). Added the Requires Plugins: contact-form-7 header.

1.1.9

• Fix: text domain reverted (again) to cf7-database-google-sheets — this is the canonical slug going forward (matches the plugin’s readable name and is what WordPress Playground / Plugin Check expects). The plugin’s packaged folder and zip are now also named cf7-database-google-sheets to match, so the slug is consistent everywhere. The GitLab project/repo itself stays named cf7-db-gsheets — only the WordPress-facing plugin slug changed.

1.1.8

• Fix: text domain reverted to cf7-db-gsheets (matches the actual plugin slug at the time) — resolved Plugin Check errors on dev.arphost.com, but broke it on WordPress Playground/Plugin Check (which expects cf7-database-google-sheets). Superseded by 1.1.9.

1.1.7

• Annotated the whitelisted ORDER BY columns for Plugin Check (documented false positive; $orderby is limited to four hardcoded column names).

1.1.6

• Text domain renamed to cf7-database-google-sheets to match the WordPress.org slug.
• Submissions query rewritten with fully literal prepared statements (resolves all Plugin Check security warnings).

1.1.5

• Plugin Check compliance: table names now use the %i identifier placeholder in all queries (requires WordPress 6.2+), removed the deprecated load_plugin_textdomain() call, and annotated intentional custom-table queries.

1.1.4

• Improvement: sheet timestamps now include the timezone. Apps Script writes Mountain Time via a TIME_ZONE constant (e.g. “2026-07-13 08:43:21 MDT”); API mode uses the WordPress timezone setting with zone label.

1.1.3

• Improvement: bundled Apps Script rewritten as a universal zero-config version — create it inside the sheet (Extensions > Apps Script), no spreadsheet ID, works with any form automatically, and reports full errors back to WordPress.

1.1.2

• Improvement: the bundled Apps Script now reports the real sheet-write error to WordPress (e.g. bad spreadsheet ID) instead of a generic “Failed to save to sheet”.

1.1.1

• Fix: Cloudflare Turnstile, hCaptcha, and other captcha tokens are no longer stored or sent to Sheets (previously only reCAPTCHA was excluded).

1.1.0

• Feature: direct Google Sheets API mode — no Apps Script required. Paste a service-account JSON key, share the sheet with the service account, done. Auto-creates one tab per form, manages columns, supports per-form routing to custom tabs or entirely different spreadsheets from the Settings screen. Webhook mode remains available.

1.0.8

• Docs: bundled Apps Script example is now a multi-form/multi-sheet router — per-form tabs (auto-created) plus optional ROUTES config to send any form to a custom tab name or a completely different spreadsheet.

1.0.7

• UI: the submissions list and detail views now show human-friendly field labels (“First Name”, “Email”, “Phone”) instead of raw CF7 field names (“first-name”, “your-email”, “tel-269”). Uses your field map, then humanizes.

1.0.6

• Feature: “Auto-map” button per form in Settings — reads the form’s fields from Contact Form 7 and fills the mapping automatically (email fields → email, tel fields → phone, “your-” prefixes stripped, names camelCased). Fields already mapped or needing no rename are skipped.

1.0.5

• Feature: every webhook payload now includes formTitle and formId, so one webhook can serve many forms (e.g. one Google Sheet tab per form). Resends include them too.

1.0.4

• Feature: forgiving field-map matching — “First Name” now matches the CF7 field “first-name” (case-insensitive; spaces and underscores count as hyphens).
• Feature: the Settings page now lists every Contact Form 7 form’s detected field names; click a field to add it to the mapping box.

1.0.3

• Fix: single-value arrays from CF7 select fields (e.g. state) are flattened to scalars in the webhook payload — Apps Script appendRow() fails silently on array values.

1.0.2

• Fix: Google rejected webhook posts with HTTP 400 — WP re-POSTs to the Apps Script 302 redirect target, which only accepts GET. The redirect is now followed manually with GET.

1.0.1

• Fix: Apps Script webhooks that return HTTP 200 with {"success":false} in the body are now correctly recorded as failed (previously marked “sent”).
• Fix: webhook timeout raised 8s → 15s to survive Apps Script cold starts.
• Docs: full field-map example (city/state/comments) matching scripts that validate required fields.

1.0.0

• Initial release: DB storage, Google Sheets webhook forwarding, admin browser, CSV export, resend, privacy-safe defaults.