eForm Easy SQL - Submission to DB & Revision Control — is an essential extension for the eForm WordPress plugin that empowers you to take full control over your form data. Instead of letting submissions sit inside the default eForm system, this plugin allows you to automatically pipe all incoming data directly into a custom table within your own WordPress database. This opens up a world of possibilities for data analysis, integration with other systems, and secure, long-term storage.
The core strength of Easy SQL lies in its simplicity and power. Through an intuitive interface, you can create new database tables or map form fields to existing ones without writing a single line of SQL code. Once configured, every new form submission is instantly and reliably saved as a new row in your designated table. Furthermore, the built-in revision control system tracks every change made to a submission, allowing you to view a complete history and restore previous versions if needed. This feature is invaluable for maintaining data accuracy and accountability, especially in collaborative environments.
Why is this important?
Are you losing valuable customer data in a cluttered inbox or a hard-to-manage default form system? Studies show that businesses that leverage customer data effectively see an 85% increase in sales growth. Without a structured way to store form submissions, you risk data loss, security vulnerabilities, and countless hours wasted on manual data entry. Imagine trying to analyze user feedback or track leads when your data is scattered across thousands of individual notifications.
eForm Easy SQL solves this by centralizing all your form data into a structured, queryable database. This not only secures your data but makes it instantly available for reporting, CRM integration, or custom application development. Stop letting valuable insights slip through the cracks and start building a powerful data asset for your business.
Features
- Automatic Submission to Database: Instantly save all eForm entries to a dedicated SQL table.
- Visual Table & Column Mapping: Easily map your form fields to database columns with a user-friendly drag-and-drop interface.
- No-Code Table Creation: Create new database tables directly from the WordPress dashboard without writing any SQL.
- Integrated Revision Control: Track all changes made to a submission, view historical versions, and restore previous states with one click.
- Frontend Submission Editing: Allow users or administrators to edit their submissions from the front end, with all changes tracked.
- Advanced Data Filtering: Search and filter your stored submissions using powerful criteria from the backend.
- CSV/XLSX Data Export: Export your submission data to popular spreadsheet formats for external analysis and reporting.
- Conditional Logic for Saving: Set up rules to only save submissions to the database if they meet specific criteria.
- Support for All eForm Fields: Seamlessly works with all standard and custom fields available in the eForm builder.
- Developer-Friendly Hooks: Provides actions and filters for developers to extend the plugin's functionality and integrate with other systems.
Time Saved with Automation
| Task | Manual Method (per week) | With eForm Easy SQL | Time Saved (per week) |
|---|---|---|---|
| Data Entry & Consolidation | 3-5 hours | 0 hours (Fully Automated) | 3-5 hours |
| Generating Custom Reports | 2-3 hours | 15 minutes (Direct SQL Query) | 1.75 - 2.75 hours |
| Tracking Submission Changes | 1-2 hours (If possible) | 5 minutes (Built-in Log) | 1-2 hours |
| Integrating with Other Systems | 5-10 hours (Custom Scripting) | 1 hour (Direct DB Access) | 4-9 hours |
| Total Weekly Savings | 11-20 hours | ~1.3 hours | ~10 - 19 hours |
How to install the plugin?
- Download the plugin archive using the button above.
- Navigate to Plugins > Add New in your WordPress dashboard.
- Click "Upload Plugin" at the top and select the downloaded ZIP file.
- Install, activate the plugin, and follow the quick setup wizard instructions.
FAQ
Does this plugin work with any WordPress form plugin?
No, eForm Easy SQL is a dedicated extension specifically designed and optimized for the "eForm - WordPress Form Builder" plugin. It relies on the core functions and hooks provided by eForm to capture submission data. It will not work as a standalone plugin or with other form builders like Contact Form 7 or Gravity Forms.
Can I save form submissions to an external (non-WordPress) database?
By default, the plugin is configured to work with the internal WordPress database ($wpdb). While direct support for external databases is not a feature in the main user interface, it is possible for a developer to use the plugin's hooks and filters to intercept the data and send it to an external database connection. This would require custom PHP coding.
What happens if I change my form after setting up the database table?
If you add, remove, or change fields in your eForm, you will need to update the table mapping in the eForm Easy SQL settings. The plugin does not automatically alter your database table structure to prevent accidental data loss. You can easily add new columns to your table for new fields or remap existing ones through the plugin's interface.
How does the revision control work and does it impact database size?
The revision control system stores a snapshot of the submission data each time it is modified. This is done in a separate, optimized table that links to the primary submission entry. While it does increase the overall database size, the impact is generally minimal unless you have a very high volume of edits on each submission. It provides a crucial audit trail, allowing you to see who changed what and when, and to restore data if a mistake is made.
