WP Data Access – WordPress App, Table and Form Builder plugin
The new data-driven App Builder includes an intuitive Table Builder and a highly customizable Form Builder, with real-time configuration changes. Apps can operate on both the back-end and front-end, with simple authorization management based on WordPress user and role principles.
App Builder
Build data-driven apps with the intuitive Table Builder and Form Builder
- Table Builder for data table generation
- Grid driven Form Builder for data management
- Intuitive Theme Builder
- Master-detail forms
- Computed fields (in real-time updatable through inline fields)
- Aggregations (in real-time updatable through inline fields)
- Conditional lookups
- Many global and inline search options
- Inline editing
- WordPress media library integration
- WordPress user and role integration
- Export options: PDF, CSV, JSON, XML, SQL, Excel
- App Manager for authorization management
- Execute apps on both back-end and front-end
- Real-time build and run functionality
Data Tables
Create professional data tables for back-end and front-end in minutes
- User-friendly and highly customizable
- Fully responsive design
- Extensive styling options with an intuitive Style Manager
- Various searching and sorting algorithms
- Numerous static and interactive filters (search panes, search forms, search builder and more)
- Server-side processing for large tables
- Client-side processing for fast search and sorting of small tables
- Export options: CSV, Excel, PDF, and SQL
- Customizable and programmable buttons
- Integrated geolocation search
- Custom queries and custom post types support
Data Apps
Build highly customizable data-driven WordPress apps for back-end and front-end
- Auto generated CRUD pages
- Customizable through Project Templates
- Lookups with drop-down lists and autocomplete fields
- Master-detail pages
- Transform Data Projects into responsive apps with Data Forms
- Inline editing capabilities
- Many search features
- WordPress role integration
- WordPress media library integration
Data Management
Manage local and remote data and databases directly from the WordPress dashboard
- Handle local and remote data and databases
- Global search and replace on multiple databases and tables
- Import SQL and CSV files (supports ZIP for large import files)
- Export options: SQL, CSV, JSON and XML (supports extremely large table exports)
- Manage table operations: rename, copy, truncate, drop, optimize, and alter
- Advanced table and column settings: search, geolocation, inline editing, and more
Remote Databases and Remote Data Files
Connect and auto-sync with remote databases and data files
- Available to all plugin tools
- Premium remote connection wizard for setup:
- Remote databases: SQL Server, Oracle, PostgreSQL, MariaDB, MySQL and MS Access (file based)
- Remote data files: CSV, JSON and XML files (e.g., sync Google Sheets)
Query Builder
Execute SQL queries directly from the WordPress dashboard
- Work on multiple SQL queries using tabs
- Save and reuse queries for data tables and charts
- Protect WordPress table structures and data
- Interactive Visual Query Builder for user with limited SQL knowledge
Dashboards and Widgets
Customizable widgets for dashboards (back-end), webpages (front-end), and external websites
- Centralized data management
- Share data widgets anywhere
- Give specific users and user groups access to locked dashboards
- User-created dashboards
- Low-cost Business Intelligence solution
Geolocation search
Create searchable geolocation maps from database tables
- Google Maps integration
- Customizable settings per database table
- DataTables integration
- Adjustable radius search map
Charts
Build charts from SQL queries
- Google Charts integration
- Integration with Query Builder and Visual Query Builder
- Various chart types selectable from drop-down lists
Data Designer
Intuitive interface for creating and managing tables and indexes
- Create and modify tables and indexes
- Support for reverse engineering and reconciliation
Plugin Settings
Detailed settings to manage the plugin’s user interface and behavior
- Customize your experience with numerous detailed plugin settings to manage user interface and functionality.