WP Data Access – WordPress App, Table and Form Builder plugin

Description

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.

Useful Links

• Plugin Website
• Documentation
• Demos
• Tutorials