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

Description

A powerful data-driven App Builder with an intuitive Table Builder, a highly customizable Form Builder and 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. The App Builder supports 35 languages to localize your apps.

App Builder

Build data-driven apps with an intuitive Table Builder and Form Builder

• Experience the simplicity of app building with our App Wizard
• Generate data tables with the Table Builder
• Manage data with the grid-driven Form Builder
• Customize with ease using the Intuitive Theme Builder
• Create (multi-level) master-detail pages with the Relationship Wizard
• Utilize real-time updatable computed fields through inline fields
• Perform real-time aggregations through inline fields
• Create (conditional) lookups with the Lookup Wizard
• Access numerous global and inline filter options
• Edit data inline seamlessly
• Connect to both local and remote databases
• Integrate with the WordPress media library
• Integrate with WordPress users and roles
• Export to PDF, CSV, JSON, XML, SQL, and Excel
• Manage authorizations with the App Manager
• Run apps on both the back-end and front-end
• Experience real-time build and run functionality
• Enjoy a fully responsive design
• Support manual styling options

Data Management

Manage local and remote data and databases directly from the WordPress dashboard

• Manage both local and remote data and databases
• Perform global search and replace across multiple databases and tables
• Import SQL and CSV files, with ZIP support for large files
• Export data in various formats: SQL, CSV, JSON, and XML, with support for large tables
• Execute table operations such as rename, copy, truncate, drop, optimize, and alter
• Access advanced table and column settings including search, geolocation, inline editing, and more

Remote Databases and Remote Data Files

Connect and auto-sync with remote databases and data files

• Compatible with all plugin tools
• Premium remote connection wizard for easy 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 with Google Sheets)

SQL 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 users 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
• Support for user-created dashboards
• Cost-effective Business Intelligence solution

Geolocation search

Create searchable geolocation maps from database tables

• Google Maps integration – Seamlessly incorporate Google Maps for geolocation features
• Customizable settings – Tailor map settings for each database table to fit your needs
• DataTables integration – Combine with DataTables for enhanced functionality
• Adjustable radius search map – Enable users to perform searches within a customizable radius

Charts

Build charts from SQL queries

• Seamless integration with Google Charts
• Compatible with both the Query Builder and Visual Query Builder
• Select from a variety of chart types using drop-down menus

Plugin Settings

Detailed settings for managing user interface and behavior

• Tailor your experience with a wide range of detailed settings to control both the user interface and functionality of the plugin

Legacy Tools

Soon replaced by the App Builder

• Available until at least summer 2025
• Use to maintain old solutions
• Use new App Builder for new projects

Data Tables (Legacy Tool)

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 including (search panes, search forms, search builder and more)
• Server-side processing for handling large tables
• Client-side processing for fast search and sorting of smaller tables
• Export options: CSV, Excel, PDF, and SQL
• Customizable and programmable buttons
• Integrated geolocation search
• Support of custom queries and custom post types

Data Apps (Legacy Tool)

Build highly customizable data-driven WordPress apps for back-end and front-end

• Automatically generated CRUD pages
• Customizable through Project Templates
• Lookups with drop-down lists and autocomplete fields
• Master-detail pages for comprehensive data management
• Transform Data Projects into responsive apps with Data Forms
• Inline editing capabilities
• Extensive search features
• Integration with WordPress user roles
• Seamless integration with the WordPress media library

Data Designer (Legacy Tool)

Intuitive interface for creating and managing tables and indexes

• Easily create and modify tables and indexes
• Support for reverse engineering and reconciliation

Useful Links

• Plugin Website
• Documentation

Screenshots

Installation

(1) Upload the WP Data Access plugin to your WordPress site
(2) Activate the plugin
(3) Navigate to the WP Data Access menu

And you’re all set!

Reviews

User-friendly reporting tool

Jean Werk August 13, 2024

I’ve only tested on a staging site so far. I’m impressed how easy it is to create back-end reports.

Excellent plugin

pmontavon July 23, 2024

The best way to access databases. Very good support and prompt reply

Very flexible and very usable plugin!

alaradar June 14, 2024

WP Data Access is a tool which I looked for a long time. It satisfied all my expectations!

Very good support and prompt reply

misterngan February 19, 2024

I was trying to move my “database” from spreadsheet to Wordpress and learning to use this plugin and explore the possibility. The staff provide very good support to me when I get stuck on somewhere.

If I could give it six stars, I would

awstyle February 6, 2024

Absolutely brilliant but one thing I would say is, you need to have a good working knowledge of databases and SQL to leverage the features of this program. I still have some bits and pieces to learn but WPDA has quickly taken me to a place far beyond where other plugins have failed. Easy to use and very customisable. Support for this product is superb. Quick and accurate responses. What more could you ask for?

Impressive

geosys98347 January 30, 2024 1 reply

Once you learn the process, it is easy to create a data application. I tried it for 2 weeks then bought the single license and will probably buy the life time licence. Finally, an easy tool for beginners to build and publish data applications to their websites.

Contributors & Developers

Changelog

5.5.16

• Released 2024-10-16
• Added: Registration form
• Added: Save view selection in App Builder
• Added: Cascading app deletion
• Added: Allow user to show | hide table columns
• Optimized: Hook editor updates to prevent unnecessary re-renders
• Changed: Bulk action column selection showing labels instead of column names
• Fixed: Join and relation table settings not saved correctly
• Fixed: Class names for styles not applied to lookup fields
• Fixed: XML export not processing null values correctly
• Fixed: App copy missing multi-level relationships
• Fixed: App export missing multi-level relationships
• Fixed: App export missing WordPress table prefix
• Fixed: App copy Data App missing detail apps
• Fixed: App export Data App missing detail apps
• Fixed: Responsiveness of data tables also set to scroll for views
• Fixed: Column filter layout when field layout is filled
• Fixed: Default detail panel overflow on mobile devices
• Fixed: Media button labels in Form Builder DELETE and SELECT not translated
• Fixed: Disable column render hook for computed fields
• Fixed: Border radius first line App Builder and Data Explorer incorrect
• Fixed: Color button labels in header
• Fixed: Border radius incorrect App Builder and Data Explorer
• Fixed: Null pointer exception on toLowerCase
• Fixed: Handle references to deleted apps
• Fixed: Cannot open table builder for data explorer
• Fixed: Show more button relation table
• Fixed: Cleanup relation table references on cancel
• Fixed: Column filter processing join and relation table columns
• Fixed: App crashes when filter is changed on detail table
• Fixed: Special characters added to column label end are moved to the front in detail view
• Fixed: Searchbox highlight replicating selected values
• Fixed: Last column disappears when it is invisible and a computed field is added
• Removed: Refresh icon from table table when inline editing is enabled
• Removed: Copy/export data apps (copy only real containers)
• Removed: Redundant free code from premium version (does not affect free version)
• Updated: Opt-in icons
• Updated: Freemius SDK

5.5.14

• Released 2024-09-17
• Added: Manage relationships from Table Builder and Form Builder
• Added: Selectable density state to App Builder and Data Explorer
• Added: Force aggregations to use column localization settings
• Added: Start apps in full screen mode
• Fixed: Reapply theme settings to app after switching
• Fixed: App Builder record lists subtract 1 day from date fields
• Fixed: Fatal error when disabling full lookup on startup
• Fixed: Column border missing in table and form builder
• Fixed: Lookup value substitution not working correctly when lookup return just one value
• Fixed: Computed field duplicated when applied multiple times on creation
• Fixed: Menu item not focusable
• Fixed: Row selection checkbox shown above row action icons when scrolling
• Fixed: Hidden columns shown when responsiveness is set to scrollbar
• Changed: Row selection column no longer pinned
• Changed: Show icon buttons on toolbar instead of buttons on small devices
• Changed: App Builder layout
• Updated: Freemius SDK= 5.5.13 =
• Released 2024-09-08
• Fixed: Events on computed fields lost
• Fixed: Textarea padding
• Fixed: Responsive column hiding
• Fixed: Padding right TH, TD
• Fixed: Table overflow issues

5.5.12

• Released 2024-09-05
• Fixed: Relation table not shown when using artificial primary key
• Fixed: Relation table join condition missing table names
• Fixed: Date not localized
• Fixed: Explicitly set background fixed columns
• Fixed: Removed migration message from Data Designer toolbar
• Fixed: Auto complete internal key mismatch
• Fixed: Image size in data table
• Added: Export to PDF icon to detail panel
• Added: Column selection in bulk actions exports
• Added: A number of hooks to customize data table layout and behaviour
• Changed: Detail panel layout
• Changed: App Builder layout
• Changed: Data Explorer layout

5.5.11

• Released 2024-08-22
• Fixed: Super admin cannot access sub site
• Fixed: Divi styling issues
• Fixed: Elementor styling issues
• Fixed: Cannot read properties of null (reading ‘toLocaleLowerCase’)
• Fixed: Full screen data app not showing table correctly
• Fixed: Inline auto save columns not saving properly
• Fixed: Cannot use % character in where clause lookups
• Fixed: Pagination rows per page setting not updated
• Fixed: M:M relationships losing primary key values
• Added: View Data Apps structure in App Builder
• Added: Copy shortcode to App Builder actions
• Added: App actions menu to the App Builder
• Added: Pagination display options: top, bottom, or both
• Added: Support for thousand and decimal separators in numeric input fields
• Added: Enhanced language support for date, time, and numeric fields
• Added: CodeMirror integration for writing computed field implementations
• Added: JavaScript and HTML support to Code Mirror
• Added: Hint to old table and form builders to prevent confusion
• Added: Inline data viewing with a detail panel
• Added: WordPress and plugin table information to the Data Explorer
• Changed: Builder resizing behaviour
• Removed: View row id from data table
• Removed: App foreign key constraints
• Updated: Freemius SDK

5.5.9

• Released 2024-07-30
• Fixed: Localization not available for date columns
• Fixed: Increase specificity table style
• Fixed: Form Builder icon always visible for master-detail relationships
• Fixed: Highlighting not working if inline HTML is enabled
• Fixed: React findDOMNode is deprecated in StrictMode
• Fixed: Invalid data type on column filter
• Fixed: Cannot reorder details
• Fixed: Cannot add column filter for hidden columns
• Fixed: Relationship display type updates not detected
• Fixed: App Manager asking for confirmation after shortcode generation
• Fixed: Inline field settings not applied
• Fixed: Undefined table settings on multi level master-detail
• Fixed: App pages on back-end missing CSS styling
• Moved: Changelog to readme (making it available online)
• Added: New app type “app container” to bundle apps into one main app
• Added: Apps to repository backup and restore
• Added: Tool replacement info.
• Added: Premium color gold to plugin menu icon.
• Added: Tool guide page also containing FAQs
• Added: Let import container wait until all databases are loaded
• Added: Added lookup placeholders to computed fields
• Added: Custom shortcode parameter support
• Added: Make computed field label in Form editable from columns list
• Added: Container ID to increase CSS specificity
• Added: Classname pp-fullscreen to body element when entering full screen mode

5.5.7

• Released 2024-07-16
• Fixed: Adding a search pane to a column with lookup requires a full table reload
• Fixed: Page scrolls down when keys f, s, t, v pressed in search boxes
• Fixed: Autocomplete not correctly showing for lookup columns with field layout set to filled or standard
• Fixed: Null value in LOV returns an empty list item
• Fixed: Filter mode ‘between inclusive’ for datetime not working correctly (same results as inclusive)
• Improved: Language files loaded moved to JSON format and loaded at runtime to improve performance
• Improved: Many textual improvements (hints, examples, labels)
• Improved: Uniformized layout and style of all field types and modes
• Improved: Computed field calculations and display
• Added: Several CSS classes for custom styling
• Added: Customize column filters width
• Added: Customize column filters ordering
• Added: Customize default page size
• Added: Customize available page sizes
• Added: Search panes
• Added: Cascading searches for lookups and lovs
• Added: Custom color picker to theme settings
• Added: HTML and JS support to computed fields
• Added: URL parameter support
• Added: Shortcode parameter support
• Added: Ability to disable full screen mode
• Added: Workaround for app preview not loading styles in Divi Visual Builder (showing no preview message instead)
• Updated: Freemius SDK

5.5.6

• Released 2024-07-02
• Fixed: Lookup search
• Fixed: User can hide column filter by clicking on filter icon even when hiding is disabled
• Fixed: Filter match highlight
• Added: Shortcode parameter to disable builders on front-end
• Added: Show column filters in table column header
• Added: Lookups missing to export
• Added: Computed fields to export
• Added: Filter match highlight to lookup columns
• Added: Column alignment to PDF export
• Added: PDF orientation and style selection
• Added: Full app localization (containing 35 languages)
• Added: Export apps
• Updated: Freemius SDK

5.5.5

• Released 2024-06-20
• Post fix: Copy app not copying details
• Post fix: New record added twice for m:m relationship
• Fixed: Force user to select at least one column on app creation or update
• Fixed: Force user to select at least one column on lookup creation or update
• Fixed: Force user to select at least one column on relationship creation or update
• Fixed: Plugin does not register lookup changes
• Fixed: Empty detail blocks visible on master insert
• Fixed: Wrong (local) date in data table (converted to UTC)
• Fixed: Row selection toggled on inline editing fields
• Fixed: Builder buttons on detail form visible to non admins
• Fixed: Media Library window appears behind the form when triggered
• Changed: Export table or app name instead of app id
• Added: Copy app link and icon
• Added: Bulk actions for views
• Added: M:m relation to App Builder
• Added: Kill token property to chart widget

5.5.4

• Released 2024-05-28
• Fixed: Lookup values not shown in exports
• Fixed: Export to pdf adds an empty column
• Fixed: Details not shown to non admin users
• Fixed: View action for tables without primary key and views
• Fixed: Table cell colors incorrect with multiple apps on one page
• Fixed: WordPress media library usage not working on insert
• Fixed: Rename view not working
• Fixed: Drop view not working
• Fixed: Link tooltips in Data Explorer not completely visible
• Fixed: Media type update not working
• Fixed: Server side updates not synced on client
• Fixed: Sending non-updatable fields to server
• Fixed: Column filters empty and not empty not working with lookups
• Fixed: Column positioning not working with full screen master-detail
• Fixed: Reduce margin bottom of error panel in Data Explorer
• Added: Alter table action to new Data Explorer
• Added: Change PDS refresh interval to new Data Explorer
• Added: Manage databases to Data Explorer
• Added: Premium Data Services access to new Data Explorer
• Added: Change font size of input fields, labels and hints
• Added: Monitor updates in App Manager
• Added: Refresh columns button to App Manager
• Added: Adjustable elevation to app containers
• Added: Use WordPress date and time format in tables
• Added: Sync root app theme with detail app theme in real time
• Added: SQL and ZIP file import to Data Explorer
• Added: Bulk actions to Data Explorer
• Added: Elevation to Papers, Cards and App Bars
• Added: Persistent search criteria in Data Explorer and App Builder

5.5.3

• Released 2024-05-15
• Improved: Column filter support
• Improved: Several builder hints
• Improved: App responsiveness
• Fixed: Cannot use view in lookups
• Fixed: Master-detail key issue
• Fixed: Database column default constraints not used
• Fixed: Lookups not used in global search
• Fixed: Multi select drop down list not working
• Fixed: Position apps list when opening App Builder
• Fixed: Error on column filter change
• Fixed: Cannot open computed field accordion
• Fixed: Column filter between not working
• Fixed: JSON parse error in Data Explorer

5.5.2

• Released 2024-05-08
• Added: Inherited font family from page
• Added: Show more|less button
• Added: Column default value
• Added: Master-detail display type
• Added: Inline HTML support to table cells
• Added: Examples to setting blocks
• Improved: Relationship configuration
• Improved: Lookup configuration
• Fixed: Date/time localization not working
• Fixed: Prefill parent data in child component
• Fixed: Lookup not respecting required constraint

5.5.1

• Released 2024-04-19
• Added: 1:1 and 1:n relationships to App Builder
• Fixed: Added client version number to prevent caching old client files
• Fixed: Geomap not working with block-based themes (Ian)
• Updated: Freemius SDK

5.5.0

• Released 2024-04-18
• Added: Pre-release new App Builder
• Fixed: URL parameter % usage

5.4.0

• Released 2024-01-25
• Added: Pre-release new Data Explorer
• Added: REST API drop-down multi-select inline search
• Added: REST API drop-down inline search
• Changed: REST API inline search and estimated row count
• Updated: Freemius SDK

< 5.4.0

• See changelog.txt in plugin folder