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

Description

A powerful data-driven App Builder with an intuitive Table Builder, a highly customizable Form Builder and interactive Chart support. 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

Unlock the simplicity of building powerful apps with our App Wizard. Customize effortlessly with our suite of Builders, Managers, and Wizards for complete control.

  • Build dynamic, data-driven apps for both front-end and back-end
  • Run apps in 35 languages to reach a global audience
  • Create fully customizable data tables for precise data display with the Table Builder
  • Design grid-based forms for streamlined data management with the Form Builder
  • Add multi-level master-detail relationships effortlessly with the Relationship Wizard
  • Edit data instantly with inline editing
  • Create lookups in a snap with the Lookup Wizard
  • Implement real-time, updatable computed fields with the Computed Field Wizard
  • Enable real-time aggregations for up-to-the-minute insights
  • Customize apps seamlessly with theme support with the Theme Builder
  • Powerful filtering options on global and column levels
  • Integrate charts for robust data analysis
  • Add custom JavaScript hooks for advanced customization
  • Manage roles and permissions with WordPress-based user authorization
  • Access the WordPress media library for enhanced functionality
  • Export to PDF, CSV, JSON, XML, SQL, and Excel
  • Real-time build and run capabilities
  • Optimized for large tables
  • Connect to local and remote databases through a visual interface
  • Execute SQL queries directly from the WordPress dashboard
  • Enjoy a fully responsive design for any device

Data Explorer

Take control of your data with our intuitive, GUI-driven Data Explorer that lets you seamlessly manage both local and remote databases right from your WordPress dashboard.

SQL Query Builder

Run SQL queries directly within WordPress.

Premium Data Services

Effortlessly connect, sync, and manage remote databases and data files.

  • Seamlessly compatible with all plugin features
  • Premium Remote Connection Wizard for fast, no-fuss setup
    • Remote Databases: Connect to SQL Server, Oracle, PostgreSQL, MariaDB, MySQL, and MS Access (file-based)
    • Remote Data Files: Sync with CSV, JSON, and XML files for dynamic updates (e.g., Google Sheets sync)

Plugin Settings

Detailed settings for managing the 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 App Builder for new projects

Dashboards and Widgets

Customizable widgets for dashboards (back-end), webpages (front-end), and external websites. (functionality will be moved to App Builder)

  • 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. (functionality will be moved to App Builder)

Useful Links

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

19 de febrero de 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.
6 de febrero de 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?
30 de enero de 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.
Read all 82 reviews

Contributors & Developers

“WP Data Access – App, Table, Form and Chart Builder plugin” is open source software. The following people have contributed to this plugin.

Contributors

“WP Data Access – App, Table, Form and Chart Builder plugin” has been translated into 1 locale. Thank you to the translators for their contributions.

Translate “WP Data Access – App, Table, Form and Chart Builder plugin” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

5.5.22

  • Released 2024-11-28
  • Added: Table component reference to table hooks
  • Added: Parameter pp-page to jump to specific page on page load
  • Added: Allow inline editing with row update disabled
  • Added: Save button to table header for inline updates
  • Added: Hide auto-increment columns during insert if visibility = off
  • Fixed: Missing form column code causes fatal error
  • Fixed: WPDAVAR and WDPATMP no longer working in SQL Query Builder
  • Fixed: Insert fails when primary key contains and auto_increment and additional columns
  • Fixed: Global search not working in free version
  • Fixed: Less than character not unescaped
  • Fixed: Lookup wizard update does not update related tables and columns
  • Changed: Freemius SDK integration
  • Optimized: Bundles and store

5.5.20

  • Released 2024-11-15
  • Fixed: Apply + OK buttons not working after closing Form Builder
  • Fixed: Null value validation not triggered on update
  • Fixed: All legacy tools removed from toolbar

5.5.19

  • Released 2024-11-15
  • Added: Enable | Disable legacy tools from tool guide page
  • Added: Allow server side default values on insert
  • Moved: Dashboards and Charts menu items to legacy tools section
  • Fixed: Tool guide header too wide on small devices
  • Fixed: Hidden elements using dashboard space
  • Fixed: Trailing comma causing error with PHP7
  • Fixed: Selector returns different results when called with same arguments
  • Fixed: Join Builder and Relation Builder button access

5.5.17

  • Released 2024-11-07
  • Added: Charts to App Builder
  • Added: Rename database feature
  • Added: Allow computed fields in forms as own element (instead of inside an input element)
  • Added: Tip to improve performance on first table load
  • Improved: Usability builder column icons
  • Fixed: Pagination issue, next button not clickable on second page
  • Fixed: Fields with inline editing enabled reflect first row value when second row is filtered
  • Fixed: Column header to wide when inline search in header is enabled
  • Fixed: Default full screen not defined
  • Fixed: Row count issue with large table support
  • Fixed: Missing mandatory column does not show error on insert
  • Fixed: Passing incorrect form mode
  • Fixed: Disable inline editing for parent ID column
  • Fixed: Populating M2M list returns unknown column in field list
  • Fixed: Insert M2M form using auto increment column
  • Fixed: Lookup relation tables returning bad request
  • Fixed: Mandatory columns not in forms prevent saving data
  • Updated: Freemius SDK

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