| @@ -1,102 +1,128 @@ | ||
| 1 | -=== WP Data Access – App, Table, Form and Chart Builder plugin === | |
| 2 | -Contributors: peterschulznl, maxxschulz, kimmyx, freemius | |
| 3 | -Tags: table builder plugin, form builder plugin, tables, data management, charts | |
| 4 | -Tested up to: 6.7 | |
| 5 | -Requires PHP: 7.0 | |
| 6 | -Stable tag: 5.5.22 | |
| 1 | +=== WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards === | |
| 2 | +Plugin URI: https://wpdataaccess.com/ | |
| 3 | +Contributors: wpdataaccess, peterschulznl, maxxschulz, kimmyx, freemius | |
| 4 | +Tags: table builder, data table, datatable, app builder, dashboard | |
| 5 | +Tested up to: 7.1 | |
| 6 | +Requires PHP: 7.4 | |
| 7 | +Stable tag: 5.5.85 | |
| 7 | 8 | License: GPLv2 or later |
| 8 | 9 | License URI: http://www.gnu.org/licenses/gpl-2.0.html |
| 9 | 10 | |
| 10 | -A powerful data-driven App Builder with an intuitive Table Builder, a highly customizable Form Builder and interactive chart support in 35 languages | |
| 11 | +Turn your data into WordPress apps with tables, forms, charts & maps — no code required, with optional hooks for developers. Supports 35+ languages. | |
| 11 | 12 | |
| 12 | 13 | == Description == |
| 13 | -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. | |
| 14 | +**WP Data Access** transforms your WordPress site into a platform for building **data-driven applications** — without writing a single line of code. | |
| 14 | 15 | |
| 15 | -== App Builder == | |
| 16 | -> Unlock the simplicity of building powerful apps with our **App Wizard**. Customize effortlessly with our suite of **Builders**, **Managers**, and **Wizards** for complete control. | |
| 16 | +With the **intuitive App Builder**, you can create: | |
| 17 | 17 | |
| 18 | -* **Build dynamic, data-driven apps** for both front-end and back-end | |
| 19 | -* **Run apps in 35 languages** to reach a global audience | |
| 20 | -* **Create fully customizable data tables** for precise data display with the **Table Builder** | |
| 21 | -* **Design grid-based forms** for streamlined data management with the **Form Builder** | |
| 22 | -* **Add multi-level master-detail relationships** effortlessly with the **Relationship Wizard** | |
| 23 | -* **Edit data instantly with inline editing** | |
| 24 | -* **Create lookups in a snap** with the **Lookup Wizard** | |
| 25 | -* **Implement real-time, updatable computed fields** with the **Computed Field Wizard** | |
| 26 | -* **Enable real-time aggregations** for up-to-the-minute insights | |
| 27 | -* **Customize apps seamlessly** with theme support with the **Theme Builder** | |
| 28 | -* **Powerful filtering options** on global and column levels | |
| 29 | -* **Integrate charts** for robust data analysis | |
| 30 | -* **Add custom JavaScript hooks for advanced customization** | |
| 31 | -* **Manage roles and permissions** with WordPress-based user authorization | |
| 32 | -* **Access the WordPress media library** for enhanced functionality | |
| 33 | -* **Export to PDF, CSV, JSON, XML, SQL, and Excel** | |
| 34 | -* **Real-time build and run capabilities** | |
| 35 | -* **Optimized for large tables** | |
| 36 | -* **Connect to local and remote databases** through a visual interface | |
| 37 | -* **Execute SQL queries directly** from the WordPress dashboard | |
| 38 | -* **Enjoy a fully responsive design** for any device | |
| 18 | +* **Interactive Data Tables** – manage and display data with ease | |
| 19 | +* **Custom Data Forms** – collect and process input seamlessly | |
| 20 | +* **Charts, Maps & Dashboards** – visualize data beautifully | |
| 21 | +* **Role-Based Access** – control who can view or manage your data | |
| 22 | +* **Multilingual Support** – 35+ languages ready to use | |
| 39 | 23 | |
| 40 | -== Data Explorer == | |
| 41 | -> 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**. | |
| 24 | +WP Data Access is designed as a **true no-code builder**: everything works out of the box, intuitive and effortless. For those who want more, a full set of **developer hooks** makes it possible to fine-tune behavior, extend functionality, or integrate with custom workflows. Hooks are completely optional and invisible to no-code users, but a powerful bonus for developers. | |
| 42 | 25 | |
| 43 | -* Effortlessly **manage data across local and remote databases** | |
| 44 | -* **Global search and replace** across multiple databases and tables | |
| 45 | -* [Easily **import SQL and CSV files**, with ZIP support for handling large datasets](https://wpdataaccess.com/docs/data-explorer-manage/imports-sql-csv/) | |
| 46 | -* [**Export data in various formats**, including SQL, CSV, JSON, and XML—even for large tables](https://wpdataaccess.com/docs/data-explorer-actions/actions/) | |
| 47 | -* Perform essential **table actions** like rename, copy, truncate, drop, optimize, and alter | |
| 48 | -* [Unlock **advanced table and column options**, such as geolocation, inline editing, and enhanced search](https://wpdataaccess.com/docs/data-explorer-settings/table-and-view-settings/) | |
| 49 | -* **Transform data management from complex to effortless with a tool designed for both flexibility and precision** | |
| 26 | +== App Builder ❤️ == | |
| 27 | +> The ultimate **data-driven Rapid Application Development tool**. Build dynamic, interactive apps in minutes with **Builders**, **Managers**, and **Wizards** — all fully customizable with Hooks. | |
| 28 | +> * Build dynamic, data-driven apps for both front-end and back-end 📱 | |
| 29 | +> * Connect to local and remote databases ⚡ | |
| 30 | +> * Real-time build and run capabilities 💻 | |
| 31 | +> * Run apps in 35+ languages to reach a global audience 🌍 | |
| 50 | 32 | |
| 33 | +* **Table Builder** - Create powerful, interactive data tables effortlessly | |
| 34 | + * Add static and dynamic data table filtering options 🔍 | |
| 35 | + * Real-time computed fields and aggregations for instant insights 📈 | |
| 36 | + * A Lookup Wizard to add lookups to your data table 🧙 | |
| 37 | + * Inline editing for instant updates 📝 | |
| 38 | + * Integrates with the WordPress media library for rich content 📷🎞 | |
| 39 | + * Export data tables to PDF, CSV, JSON, XML, SQL, and Excel 📄 | |
| 40 | + * Add charts and maps to your data table header and footer 📊 | |
| 41 | + * JavaScript hooks to customize data table layout and behavior 🔧 | |
| 42 | +* **Form Builder** - Design forms that adapt to your workflow | |
| 43 | + * Grid-based layouts for precise control ➕➖ | |
| 44 | + * Master-detail relationships for multi-level data structures 🔄 | |
| 45 | + * Lookup and Computed Field Wizards to add functionality instantly 🧙 | |
| 46 | + * Interactive client-side validations tied to your database constraints ✅ | |
| 47 | + * Full access to the WordPress media library 📷🎞 | |
| 48 | + * JavaScript hooks to customize business rules, validations and layout 🔧 | |
| 49 | +* **Chart Builder** - Transform your data into visual insights | |
| 50 | + * Google Charts integration 📊 | |
| 51 | + * Create charts from SQL queries 📑 | |
| 52 | + * Interactively adjustable chart configurations ✔ | |
| 53 | + * Print/export charts 🖨📄 | |
| 54 | +* **Map Builder** - Visualize your data geographically | |
| 55 | + * Google Maps integration for location-based apps 🌎 | |
| 56 | + * Query-driven location visualizations 📍 | |
| 57 | + * Interactively adjustable search radius 🔍 | |
| 58 | + * Customizable marker content and layout 📌 | |
| 59 | +* **Dashboard Builder** - Centralize insights with customizable widgets | |
| 60 | + * Combine all app types into cohesive dashboards ✅ | |
| 61 | + * Customize dashboard layouts with flexible positioning and sizing ➕➖ | |
| 62 | + * Customizable widgets presenting dynamic and static data | |
| 63 | + * Mix real-time data with fixed information for comprehensive overviews 📊 | |
| 64 | +* **Theme Builder** - Make your app truly yours | |
| 65 | + * Personalize your app’s appearance with ease 🎨 | |
| 66 | +* **App Manager** - Control your apps with confidence | |
| 67 | + * Authorization management based on WordPress user and role principles 🔒 | |
| 68 | + * Add apps to back-end menus or front-end pages via shortcodes 🔽🌐 | |
| 69 | + * Safe mode to temporarily disable hooks without breaking functionality 🔧 | |
| 70 | + | |
| 71 | +[youtube https://www.youtube.com/watch?v=j0MJvuMG7k8] | |
| 72 | + | |
| 51 | 73 | == SQL Query Builder == |
| 52 | -> **Run SQL queries directly within WordPress.** | |
| 74 | +> **Run and schedule SQL queries** effortlessly from your WordPress dashboard. | |
| 53 | 75 | |
| 54 | -* [Execute multiple SQL queries with **tabbed workflows** for seamless multitasking](https://wpdataaccess.com/docs/query-builder/query-builder-tutorials/) | |
| 55 | -* **Save and reuse queries** for data tables and charts | |
| 56 | -* **Built-in safeguards to protect WordPress tables** and data integrity | |
| 57 | -* [Ready to optimize? Explore the intuitive **Visual Query Builder** for easy query creation, even without SQL expertise](https://wpdataaccess.com/docs/query-builder/visual-query-builder/) | |
| 76 | +* Schedule queries to run automatically at defined intervals 🕝 | |
| 77 | +* Run **batch jobs** for **automated data exchange** across multiple databases 🤝 | |
| 78 | +* AI Assistant to generate queries and fix common errors 🤖 | |
| 79 | +* Tabbed interface for running multiple queries in parallel ▶ | |
| 80 | +* Save and reuse queries - privately or globally 🔄 | |
| 81 | +* Built-in safeguards to protect core WordPress tables and ensure data integrity 🔒 | |
| 82 | +* Visual Query Builder to create complex queries without writing SQL 🎨 | |
| 58 | 83 | |
| 59 | -== Premium Data Services == | |
| 60 | -> **Effortlessly connect, sync, and manage remote databases and data files.** | |
| 84 | +== Data Explorer == | |
| 85 | +> Take full control of your data with a **GUI-driven interface**. | |
| 61 | 86 | |
| 62 | -* **Seamlessly compatible with all plugin features** | |
| 63 | -* [Premium Remote Connection Wizard for fast, no-fuss setup](https://wpdataaccess.com/docs/remote-connection-wizard/remote-connection-wizard/) | |
| 64 | - * **Remote Databases**: Connect to SQL Server, Oracle, PostgreSQL, MariaDB, MySQL, and MS Access (file-based) | |
| 65 | - * **Remote Data Files**: Sync with CSV, JSON, and XML files for dynamic updates (e.g., Google Sheets sync) | |
| 87 | +* Manage local and remote data 🗺 | |
| 88 | +* Perform global search and replace across multiple databases and tables 🔍 | |
| 89 | +* Import SQL and CSV files, with ZIP support for handling large datasets 📄 | |
| 90 | +* Export data in various formats, including SQL, CSV, JSON, and XML 📄 | |
| 91 | +* Rename, copy, truncate, drop, optimize, or alter tables 👤 | |
| 92 | +* Advanced table and column options, such as geolocation, and enhanced search ✔ | |
| 66 | 93 | |
| 67 | -== Plugin Settings == | |
| 68 | -> Detailed settings for **managing the user interface and behavior**. | |
| 94 | +== Premium Data Services == | |
| 95 | +> **Connect, sync, and manage remote databases and data files.** | |
| 69 | 96 | |
| 70 | -* Tailor your experience with a wide range of detailed settings to control both the user interface and functionality of the plugin | |
| 97 | +* Compatible with all plugin features ✅ | |
| 98 | +* Premium Remote Connection Wizard 🧙 | |
| 99 | + * Remote Databases: Connect to SQL Server, Oracle, PostgreSQL, MariaDB, MySQL, and MS Access (file-based) 💻 | |
| 100 | + * Remote Data Files: Sync with CSV, JSON, and XML files for dynamic updates (e.g., Google Sheets sync) 📄 | |
| 71 | 101 | |
| 72 | 102 | == Legacy Tools == |
| 73 | -> Soon replaced by the **App Builder**. | |
| 103 | +> Will be replaced by the **App Builder**. | |
| 74 | 104 | |
| 75 | -* Available until at least summer 2025 | |
| 76 | -* Use to maintain old solutions | |
| 77 | -* Use **App Builder** for new projects | |
| 105 | +* Featuring | |
| 106 | + * Data Tables 🔍 - Replace with Data Table app. | |
| 107 | + * Data Forms ✅ - Replace with Data Management app or Registration Form. | |
| 108 | + * Maps 🌎 - Replace with Map app. | |
| 109 | + * Charts 📊 - Replace with Chart app. | |
| 110 | + * Dashboards 🎛️ - Replace with Dashboard app. | |
| 111 | +* Use to maintain old solutions 🙏 | |
| 112 | +* Use App Builder for new projects 🚀 | |
| 113 | +* You can continue to use the legacy tools by staying on the latest Version 5.x ([Read more →](https://docs.legacy.wpdataaccess.com/docs/deprecating/)) | |
| 78 | 114 | |
| 79 | -== Dashboards and Widgets == | |
| 80 | -> Customizable widgets for dashboards (back-end), webpages (front-end), and external websites. **(functionality will be moved to App Builder)** | |
| 81 | - | |
| 82 | -* Centralized data management | |
| 83 | -* Share data widgets anywhere | |
| 84 | -* Give specific users and user groups access to locked dashboards | |
| 85 | -* Support for user-created dashboards | |
| 86 | -* Cost-effective Business Intelligence solution | |
| 87 | - | |
| 88 | -== Geolocation search == | |
| 89 | -> Create searchable geolocation maps from database tables. **(functionality will be moved to App Builder)** | |
| 90 | - | |
| 91 | -* Google Maps integration – Seamlessly incorporate Google Maps for geolocation features | |
| 92 | -* Customizable settings – Tailor map settings for each database table to fit your needs | |
| 93 | -* [DataTables integration – Combine with DataTables for enhanced functionality](https://wpdataaccess.com/publication-using-geolocation/) | |
| 94 | -* [Adjustable radius search map – Enable users to perform searches within a customizable radius](https://wpdataaccess.com/demos/geolocation-demo/) | |
| 95 | - | |
| 96 | 115 | == Useful Links == |
| 97 | 116 | - [Plugin Website](https://wpdataaccess.com/) |
| 98 | -- [Documentation](https://wpdataaccess.com/documentation/) | |
| 117 | +- [Demos](https://wpdataaccess.com/demos/) | |
| 118 | +- [Tutorials](https://wpdataaccess.com/tutorials/) | |
| 119 | +- [App Builder Documentation](https://docs.rad.wpdataaccess.com/) | |
| 120 | +- [Video Tutorials](https://www.youtube.com/@wpdataaccess) | |
| 121 | +- [SQL Query Builder Documentation](https://docs.sql.wpdataaccess.com/) | |
| 122 | +- [Plugin Settings Documentation](https://docs.settings.wpdataaccess.com/) | |
| 123 | +- [Tool Guide Documentation](https://docs.wpdataaccess.com/) | |
| 124 | +- [Legacy Documentation](https://docs.legacy.wpdataaccess.com/) | |
| 99 | 125 | |
| 100 | 126 | == Installation == |
| 101 | 127 | (1) Upload the WP Data Access plugin to your WordPress site |
| 102 | 128 | (2) Activate the plugin |
| @@ -101,347 +127,197 @@ | ||
| 101 | 127 | (1) Upload the WP Data Access plugin to your WordPress site |
| 102 | 128 | (2) Activate the plugin |
| 103 | 129 | (3) Navigate to the WP Data Access menu |
| 104 | 130 | |
| 105 | -And you're all set! | |
| 131 | +And you're all set! 🚀 | |
| 106 | 132 | |
| 107 | 133 | == Changelog == |
| 108 | 134 | |
| 109 | -= 5.5.22 = | |
| 110 | -* Released 2024-11-28 | |
| 111 | -* Added: Table component reference to table hooks | |
| 112 | -* Added: Parameter pp-page to jump to specific page on page load | |
| 113 | -* Added: Allow inline editing with row update disabled | |
| 114 | -* Added: Save button to table header for inline updates | |
| 115 | -* Added: Hide auto-increment columns during insert if visibility = off | |
| 116 | -* Fixed: Missing form column code causes fatal error | |
| 117 | -* Fixed: WPDAVAR and WDPATMP no longer working in SQL Query Builder | |
| 118 | -* Fixed: Insert fails when primary key contains and auto_increment and additional columns | |
| 119 | -* Fixed: Global search not working in free version | |
| 120 | -* Fixed: Less than character not unescaped | |
| 121 | -* Fixed: Lookup wizard update does not update related tables and columns | |
| 122 | -* Changed: Freemius SDK integration | |
| 123 | -* Optimized: Bundles and store | |
| 135 | += 5.5.85 = | |
| 136 | +* Released 2026-09-23 | |
| 137 | +* Removed unsed code | |
| 138 | +* Added: Exclude columns from export | |
| 139 | +* Added: Aggregation translations | |
| 140 | +* Fixed: Default values not applied to M:M relationships | |
| 141 | +* Fixed: Enum and set drop-down height | |
| 142 | +* Fixed: Removed column still available for export | |
| 143 | +* Fixed: Access parameter validation | |
| 144 | +* Fixed: Cannot open hooks menu for relation table | |
| 124 | 145 | |
| 125 | -= 5.5.20 = | |
| 126 | -* Released 2024-11-15 | |
| 127 | -* Fixed: Apply + OK buttons not working after closing Form Builder | |
| 128 | -* Fixed: Null value validation not triggered on update | |
| 129 | -* Fixed: All legacy tools removed from toolbar | |
| 146 | += 5.5.84 = | |
| 147 | +* Released 2026-09-17 | |
| 148 | +* Restructured table column renderer | |
| 149 | +* Removed unsed code | |
| 150 | +* Added: Column pinning to data tables | |
| 151 | +* Added: Rename database to app menu | |
| 152 | +* Added: Class name to lookup popup | |
| 153 | +* Added: Data label to lookup items | |
| 154 | +* Added: Show hidden columns on tablets and mobiles | |
| 155 | +* Fixed: setColumnStyle on lookup columns | |
| 156 | +* Fixed: Map markers not working in Data Table and Data Admin apps | |
| 157 | +* Fixed: Scheduled tasks deleted on version update | |
| 130 | 158 | |
| 131 | -= 5.5.19 = | |
| 132 | -* Released 2024-11-15 | |
| 133 | -* Added: Enable | Disable legacy tools from tool guide page | |
| 134 | -* Added: Allow server side default values on insert | |
| 135 | -* Moved: Dashboards and Charts menu items to legacy tools section | |
| 136 | -* Fixed: Tool guide header too wide on small devices | |
| 137 | -* Fixed: Hidden elements using dashboard space | |
| 138 | -* Fixed: Trailing comma causing error with PHP7 | |
| 139 | -* Fixed: Selector returns different results when called with same arguments | |
| 140 | -* Fixed: Join Builder and Relation Builder button access | |
| 159 | += 5.5.83 = | |
| 160 | +* Released 2026-09-09 | |
| 161 | +* Added: Default column name based class names to form fields | |
| 162 | +* Removed old Query Builder | |
| 163 | +* Removed import from legacy list table | |
| 164 | +* Fixed: Query Builder fails rebuilding multiple tabs | |
| 165 | +* Fixed: WPDAVAR not working in Query Builder | |
| 166 | +* Fixed: Chart legend position top wrapped | |
| 167 | +* Fixed: Initial "skip relation table pre-search step" setting not processed correctly | |
| 168 | +* Fixed: Auto increment column value missing in insert m:m relationship | |
| 169 | +* Fixed: Custom classes not applied in forms | |
| 170 | +* Fixed: App not correct exported when regexp is used in a hook | |
| 171 | +* Fixed: Confirm dialog alignment | |
| 172 | +* Fixed: Unicode characters not imported correct on app transfer | |
| 173 | +* Fixed: Lookup value not synchronized on update with client side processing enabled | |
| 174 | +* Fixed: Cannot zoom in|out in maps | |
| 175 | +* Fixed: Null values added to unselected columns on insert | |
| 176 | +* Fixed: CSS Form Editor help link | |
| 177 | +* Fixed: Shortcode parameter vulnerability in legacy data tables | |
| 141 | 178 | |
| 142 | -= 5.5.17 = | |
| 143 | -* Released 2024-11-07 | |
| 144 | -* Added: Charts to App Builder | |
| 145 | -* Added: Rename database feature | |
| 146 | -* Added: Allow computed fields in forms as own element (instead of inside an input element) | |
| 147 | -* Added: Tip to improve performance on first table load | |
| 148 | -* Improved: Usability builder column icons | |
| 149 | -* Fixed: Pagination issue, next button not clickable on second page | |
| 150 | -* Fixed: Fields with inline editing enabled reflect first row value when second row is filtered | |
| 151 | -* Fixed: Column header to wide when inline search in header is enabled | |
| 152 | -* Fixed: Default full screen not defined | |
| 153 | -* Fixed: Row count issue with large table support | |
| 154 | -* Fixed: Missing mandatory column does not show error on insert | |
| 155 | -* Fixed: Passing incorrect form mode | |
| 156 | -* Fixed: Disable inline editing for parent ID column | |
| 157 | -* Fixed: Populating M2M list returns unknown column in field list | |
| 158 | -* Fixed: Insert M2M form using auto increment column | |
| 159 | -* Fixed: Lookup relation tables returning bad request | |
| 160 | -* Fixed: Mandatory columns not in forms prevent saving data | |
| 161 | -* Updated: Freemius SDK | |
| 179 | += 5.5.82 = | |
| 180 | +* Released 2026-08-26 | |
| 181 | +* Added: App context to computed form fields | |
| 182 | +* Added: Localize WordPress standard date format | |
| 183 | +* Added: Skip relation table pre-search step | |
| 184 | +* Changed: Query Builder tab styling | |
| 185 | +* Fixed: Class name not added to computed field | |
| 186 | +* Fixed: Disable media action buttons for anonymous users | |
| 187 | +* Fixed: Media library not launched in fullscreen mode | |
| 188 | +* Fixed: Removed unused columns from response | |
| 189 | +* Fixed: Reevaluation of already substituted placeholders | |
| 190 | +* Fixed: Table settings crash when changing media to secure document | |
| 191 | +* Fixed: Theme font size does not size table cells | |
| 192 | +* Fixed: Media columns missing class names | |
| 193 | +* Fixed: Dynamic lookup over multiple columns not populated in insert mode | |
| 194 | +* Fixed: Query not scheduled | |
| 195 | +* Fixed: Numeric columns labels not processed correctly in Query Builder | |
| 196 | +* Fixed: Numeric columns labels not processed correctly in charts | |
| 197 | +* Fixed: Inline editing global save not working | |
| 162 | 198 | |
| 163 | -= 5.5.16 = | |
| 164 | -* Released 2024-10-16 | |
| 165 | -* Added: Registration form | |
| 166 | -* Added: Save view selection in App Builder | |
| 167 | -* Added: Cascading app deletion | |
| 168 | -* Added: Allow user to show | hide table columns | |
| 169 | -* Optimized: Hook editor updates to prevent unnecessary re-renders | |
| 170 | -* Changed: Bulk action column selection showing labels instead of column names | |
| 171 | -* Fixed: Join and relation table settings not saved correctly | |
| 172 | -* Fixed: Class names for styles not applied to lookup fields | |
| 173 | -* Fixed: XML export not processing null values correctly | |
| 174 | -* Fixed: App copy missing multi-level relationships | |
| 175 | -* Fixed: App export missing multi-level relationships | |
| 176 | -* Fixed: App export missing WordPress table prefix | |
| 177 | -* Fixed: App copy Data App missing detail apps | |
| 178 | -* Fixed: App export Data App missing detail apps | |
| 179 | -* Fixed: Responsiveness of data tables also set to scroll for views | |
| 180 | -* Fixed: Column filter layout when field layout is filled | |
| 181 | -* Fixed: Default detail panel overflow on mobile devices | |
| 182 | -* Fixed: Media button labels in Form Builder DELETE and SELECT not translated | |
| 183 | -* Fixed: Disable column render hook for computed fields | |
| 184 | -* Fixed: Border radius first line App Builder and Data Explorer incorrect | |
| 185 | -* Fixed: Color button labels in header | |
| 186 | -* Fixed: Border radius incorrect App Builder and Data Explorer | |
| 187 | -* Fixed: Null pointer exception on toLowerCase | |
| 188 | -* Fixed: Handle references to deleted apps | |
| 189 | -* Fixed: Cannot open table builder for data explorer | |
| 190 | -* Fixed: Show more button relation table | |
| 191 | -* Fixed: Cleanup relation table references on cancel | |
| 192 | -* Fixed: Column filter processing join and relation table columns | |
| 193 | -* Fixed: App crashes when filter is changed on detail table | |
| 194 | -* Fixed: Special characters added to column label end are moved to the front in detail view | |
| 195 | -* Fixed: Searchbox highlight replicating selected values | |
| 196 | -* Fixed: Last column disappears when it is invisible and a computed field is added | |
| 197 | -* Removed: Refresh icon from table table when inline editing is enabled | |
| 198 | -* Removed: Copy/export data apps (copy only real containers) | |
| 199 | -* Removed: Redundant free code from premium version (does not affect free version) | |
| 200 | -* Updated: Opt-in icons | |
| 201 | -* Updated: Freemius SDK | |
| 199 | += 5.5.81 = | |
| 200 | +* Released 2026-08-18 | |
| 201 | +* Removed old Data Explorer | |
| 202 | +* Changed global search & replace | |
| 203 | +* Changed tool guide page | |
| 204 | +* Added: Secure document storage | |
| 205 | +* Added: Form separators with title feature | |
| 206 | +* Added: CSS Form Editor | |
| 207 | +* Added: Data Explorer documentation | |
| 208 | +* Fixed: Allow admins only to configure lookups | |
| 209 | +* Fixed: Check authorization for wildcard exports | |
| 210 | +* Fixed: Database administration page shows invalid database list | |
| 211 | +* Fixed: Missing scale in hint | |
| 212 | +* Fixed: Reevaluation of already substituted placeholders | |
| 213 | +* Fixed: Cannot add new table design | |
| 214 | +* Fixed: Scheduled query not correctly returning rows affected | |
| 202 | 215 | |
| 203 | -= 5.5.14 = | |
| 204 | -* Released 2024-09-17 | |
| 205 | -* Added: Manage relationships from Table Builder and Form Builder | |
| 206 | -* Added: Selectable density state to App Builder and Data Explorer | |
| 207 | -* Added: Force aggregations to use column localization settings | |
| 208 | -* Added: Start apps in full screen mode | |
| 209 | -* Fixed: Reapply theme settings to app after switching | |
| 210 | -* Fixed: App Builder record lists subtract 1 day from date fields | |
| 211 | -* Fixed: Fatal error when disabling full lookup on startup | |
| 212 | -* Fixed: Column border missing in table and form builder | |
| 213 | -* Fixed: Lookup value substitution not working correctly when lookup return just one value | |
| 214 | -* Fixed: Computed field duplicated when applied multiple times on creation | |
| 215 | -* Fixed: Menu item not focusable | |
| 216 | -* Fixed: Row selection checkbox shown above row action icons when scrolling | |
| 217 | -* Fixed: Hidden columns shown when responsiveness is set to scrollbar | |
| 218 | -* Changed: Row selection column no longer pinned | |
| 219 | -* Changed: Show icon buttons on toolbar instead of buttons on small devices | |
| 220 | -* Changed: App Builder layout | |
| 221 | -* Updated: Freemius SDK | |
| 216 | += 5.5.80 = | |
| 217 | +* Released 2026-08-06 | |
| 218 | +* Added: Progressive web apps | |
| 219 | +* Fixed: Escaped titles and links in table output and shortcode | |
| 220 | +* Fixed: Hide inline editing feature when update is not allowed | |
| 221 | +* Fixed: Table incorrectly styled after abandoning card view | |
| 222 | 222 | |
| 223 | -== Changelog == | |
| 224 | -= 5.5.13 = | |
| 225 | -* Released 2024-09-08 | |
| 226 | -* Fixed: Events on computed fields lost | |
| 227 | -* Fixed: Textarea padding | |
| 228 | -* Fixed: Responsive column hiding | |
| 229 | -* Fixed: Padding right TH, TD | |
| 230 | -* Fixed: Table overflow issues | |
| 223 | += 5.5.79 = | |
| 224 | +* Released 2026-07-29 | |
| 225 | +* Added: Legacy tools message (widget and notice) | |
| 226 | +* Added: Network errors to app messages for improved troubleshooting | |
| 227 | +* Fixed: Cannot disable global filter for columns with client-side processing | |
| 228 | +* Fixed: Client-side cascading column filter count | |
| 229 | +* Fixed: Styling issues with column filter popup | |
| 230 | +* Fixed: Client-side drop-down column filters not showing alternative values | |
| 231 | +* Fixed: Clicking the create table design icon returns unauthorized | |
| 232 | +* Fixed: Button style overwritten by theme CSS | |
| 233 | +* Extended nonce action (Farid) | |
| 231 | 234 | |
| 232 | -= 5.5.12 = | |
| 233 | -* Released 2024-09-05 | |
| 234 | -* Fixed: Relation table not shown when using artificial primary key | |
| 235 | -* Fixed: Relation table join condition missing table names | |
| 236 | -* Fixed: Date not localized | |
| 237 | -* Fixed: Explicitly set background fixed columns | |
| 238 | -* Fixed: Removed migration message from Data Designer toolbar | |
| 239 | -* Fixed: Auto complete internal key mismatch | |
| 240 | -* Fixed: Image size in data table | |
| 241 | -* Added: Export to PDF icon to detail panel | |
| 242 | -* Added: Column selection in bulk actions exports | |
| 243 | -* Added: A number of hooks to customize data table layout and behaviour | |
| 244 | -* Changed: Detail panel layout | |
| 245 | -* Changed: App Builder layout | |
| 246 | -* Changed: Data Explorer layout | |
| 235 | += 5.5.77 = | |
| 236 | +* Released 2026-07-17 | |
| 237 | +* Added: Gutenberg block support for [wpda_app] shortcode | |
| 238 | +* Added: Display multiple cards per row | |
| 239 | +* Added: Missing parameters for shortcode generation | |
| 240 | +* Added: Check for unsaved changes in Visual Query Builder on close | |
| 241 | +* Changed: Inline editing now requires update enabled (use option "hide edit icon") | |
| 242 | +* Changed: Cascading column filter behavior | |
| 243 | +* Fixed: Cascading column filters with client-side processing | |
| 244 | +* Fixed: CSV import button icons alignment | |
| 245 | +* Fixed: Lazy loaded lookups not rerendering when open | |
| 246 | +* Fixed: Visual Query conversion | |
| 247 | +* Fixed: Visual Query Builder column row layout | |
| 248 | +* Fixed: Visual Query Builder alias not editable | |
| 249 | +* Fixed: Visual Query Builder missing plus icon button | |
| 250 | +* CSS Table Editor now available to free users | |
| 251 | +* Added css class pp-table-detail-panel-container to detail panel | |
| 252 | +* Code review | |
| 253 | +* Extended nonce action | |
| 254 | +* Updated freemius SDK | |
| 247 | 255 | |
| 248 | -= 5.5.11 = | |
| 249 | -* Released 2024-08-22 | |
| 250 | -* Fixed: Super admin cannot access sub site | |
| 251 | -* Fixed: Divi styling issues | |
| 252 | -* Fixed: Elementor styling issues | |
| 253 | -* Fixed: Cannot read properties of null (reading 'toLocaleLowerCase') | |
| 254 | -* Fixed: Full screen data app not showing table correctly | |
| 255 | -* Fixed: Inline auto save columns not saving properly | |
| 256 | -* Fixed: Cannot use % character in where clause lookups | |
| 257 | -* Fixed: Pagination rows per page setting not updated | |
| 258 | -* Fixed: M:M relationships losing primary key values | |
| 259 | -* Added: View Data Apps structure in App Builder | |
| 260 | -* Added: Copy shortcode to App Builder actions | |
| 261 | -* Added: App actions menu to the App Builder | |
| 262 | -* Added: Pagination display options: top, bottom, or both | |
| 263 | -* Added: Support for thousand and decimal separators in numeric input fields | |
| 264 | -* Added: Enhanced language support for date, time, and numeric fields | |
| 265 | -* Added: CodeMirror integration for writing computed field implementations | |
| 266 | -* Added: JavaScript and HTML support to Code Mirror | |
| 267 | -* Added: Hint to old table and form builders to prevent confusion | |
| 268 | -* Added: Inline data viewing with a detail panel | |
| 269 | -* Added: WordPress and plugin table information to the Data Explorer | |
| 270 | -* Changed: Builder resizing behaviour | |
| 271 | -* Removed: View row id from data table | |
| 272 | -* Removed: App foreign key constraints | |
| 273 | -* Updated: Freemius SDK | |
| 256 | += 5.5.76 = | |
| 257 | +* Released 2026-07-07 | |
| 258 | +* Added: Extended pagination button support for all data tables | |
| 259 | +* Fixed: Column filter popup should only count rows with client-side processing enabled | |
| 260 | +* Fixed: Update fails after navigating to other row for 1:1 relationships | |
| 261 | +* Fixed: Last pagination button missing | |
| 262 | +* Fixed: Search list not updated | |
| 263 | +* Fixed: Cross-Site Scripting (XSS) vulnerability - patchstack | |
| 264 | +* Fixed: Function setColumnStyle has no effect on first column | |
| 265 | +* Fixed: Cascade drop-down lists not taking global filter into account with client-side processing enabled | |
| 266 | +* Fixed: Cannot position column filters above | |
| 267 | +* Updated freemius SDK | |
| 274 | 268 | |
| 275 | -= 5.5.9 = | |
| 276 | -* Released 2024-07-30 | |
| 277 | -* Fixed: Localization not available for date columns | |
| 278 | -* Fixed: Increase specificity table style | |
| 279 | -* Fixed: Form Builder icon always visible for master-detail relationships | |
| 280 | -* Fixed: Highlighting not working if inline HTML is enabled | |
| 281 | -* Fixed: React findDOMNode is deprecated in StrictMode | |
| 282 | -* Fixed: Invalid data type on column filter | |
| 283 | -* Fixed: Cannot reorder details | |
| 284 | -* Fixed: Cannot add column filter for hidden columns | |
| 285 | -* Fixed: Relationship display type updates not detected | |
| 286 | -* Fixed: App Manager asking for confirmation after shortcode generation | |
| 287 | -* Fixed: Inline field settings not applied | |
| 288 | -* Fixed: Undefined table settings on multi level master-detail | |
| 289 | -* Fixed: App pages on back-end missing CSS styling | |
| 290 | -* Moved: Changelog to readme (making it available online) | |
| 291 | -* Added: New app type "app container" to bundle apps into one main app | |
| 292 | -* Added: Apps to repository backup and restore | |
| 293 | -* Added: Tool replacement info. | |
| 294 | -* Added: Premium color gold to plugin menu icon. | |
| 295 | -* Added: Tool guide page also containing FAQs | |
| 296 | -* Added: Let import container wait until all databases are loaded | |
| 297 | -* Added: Added lookup placeholders to computed fields | |
| 298 | -* Added: Custom shortcode parameter support | |
| 299 | -* Added: Make computed field label in Form editable from columns list | |
| 300 | -* Added: Container ID to increase CSS specificity | |
| 301 | -* Added: Classname pp-fullscreen to body element when entering full screen mode | |
| 269 | += 5.5.75 = | |
| 270 | +* Released 2026-06-25 | |
| 271 | +* Added: New Visual Query Builder | |
| 272 | +* Added: Column filters popup positioning | |
| 273 | +* Added: Class names to action buttons | |
| 274 | +* Updated freemius SDK | |
| 302 | 275 | |
| 303 | -= 5.5.7 = | |
| 304 | -* Released 2024-07-16 | |
| 305 | -* Fixed: Adding a search pane to a column with lookup requires a full table reload | |
| 306 | -* Fixed: Page scrolls down when keys f, s, t, v pressed in search boxes | |
| 307 | -* Fixed: Autocomplete not correctly showing for lookup columns with field layout set to filled or standard | |
| 308 | -* Fixed: Null value in LOV returns an empty list item | |
| 309 | -* Fixed: Filter mode 'between inclusive' for datetime not working correctly (same results as inclusive) | |
| 310 | -* Improved: Language files loaded moved to JSON format and loaded at runtime to improve performance | |
| 311 | -* Improved: Many textual improvements (hints, examples, labels) | |
| 312 | -* Improved: Uniformized layout and style of all field types and modes | |
| 313 | -* Improved: Computed field calculations and display | |
| 314 | -* Added: Several CSS classes for custom styling | |
| 315 | -* Added: Customize column filters width | |
| 316 | -* Added: Customize column filters ordering | |
| 317 | -* Added: Customize default page size | |
| 318 | -* Added: Customize available page sizes | |
| 319 | -* Added: Search panes | |
| 320 | -* Added: Cascading searches for lookups and lovs | |
| 321 | -* Added: Custom color picker to theme settings | |
| 322 | -* Added: HTML and JS support to computed fields | |
| 323 | -* Added: URL parameter support | |
| 324 | -* Added: Shortcode parameter support | |
| 325 | -* Added: Ability to disable full screen mode | |
| 326 | -* Added: Workaround for app preview not loading styles in Divi Visual Builder (showing no preview message instead) | |
| 327 | -* Updated: Freemius SDK | |
| 276 | += 5.5.74 = | |
| 277 | +* Released 2026-05-21 | |
| 278 | +* Fixed: Expand column filters on startup not available for POPUPs | |
| 279 | +* Fixed: Must manually enable "show column filters in compact mode" for POPUPs | |
| 280 | +* Fixed: Border between column filters on left to fat | |
| 328 | 281 | |
| 329 | -= 5.5.6 = | |
| 330 | -* Released 2024-07-02 | |
| 331 | -* Fixed: Lookup search | |
| 332 | -* Fixed: User can hide column filter by clicking on filter icon even when hiding is disabled | |
| 333 | -* Fixed: Filter match highlight | |
| 334 | -* Added: Shortcode parameter to disable builders on front-end | |
| 335 | -* Added: Show column filters in table column header | |
| 336 | -* Added: Lookups missing to export | |
| 337 | -* Added: Computed fields to export | |
| 338 | -* Added: Filter match highlight to lookup columns | |
| 339 | -* Added: Column alignment to PDF export | |
| 340 | -* Added: PDF orientation and style selection | |
| 341 | -* Added: Full app localization (containing 35 languages) | |
| 342 | -* Added: Export apps | |
| 343 | -* Updated: Freemius SDK | |
| 282 | += 5.5.73 = | |
| 283 | +* Released 2026-05-19 | |
| 284 | +* Added: Feedback to compact column filter buttons | |
| 285 | +* Added: Show column filters in popup | |
| 286 | +* Added: Single-select search panes | |
| 287 | +* Added: Selectable plus|min icons for numeric fields | |
| 288 | +* Added: Disable plus|min icons for numeric fields | |
| 289 | +* Improved column filters UI | |
| 290 | +* Improved bulk actions UI | |
| 291 | +* Optimized column filter handling | |
| 292 | +* Fixed: Cannot start table with docked chart in fullscreen mode | |
| 293 | +* Fixed: Search fields containing two clear icon buttons | |
| 294 | +* Fixed: Highlighting fails for wildcards | |
| 295 | +* Fixed: Dynamic conditions not available after lookup update | |
| 296 | +* Fixed: Default column search fails if URL parameter does not exist | |
| 297 | +* Fixed: Dynamic lookup fails with unequal column names | |
| 298 | +* Fixed: Column filters not consistently working with async lookups | |
| 299 | +* Fixed: Cascading search for search boxes | |
| 344 | 300 | |
| 345 | -= 5.5.5 = | |
| 346 | -* Released 2024-06-20 | |
| 347 | -* Post fix: Copy app not copying details | |
| 348 | -* Post fix: New record added twice for m:m relationship | |
| 349 | -* Fixed: Force user to select at least one column on app creation or update | |
| 350 | -* Fixed: Force user to select at least one column on lookup creation or update | |
| 351 | -* Fixed: Force user to select at least one column on relationship creation or update | |
| 352 | -* Fixed: Plugin does not register lookup changes | |
| 353 | -* Fixed: Empty detail blocks visible on master insert | |
| 354 | -* Fixed: Wrong (local) date in data table (converted to UTC) | |
| 355 | -* Fixed: Row selection toggled on inline editing fields | |
| 356 | -* Fixed: Builder buttons on detail form visible to non admins | |
| 357 | -* Fixed: Media Library window appears behind the form when triggered | |
| 358 | -* Changed: Export table or app name instead of app id | |
| 359 | -* Added: Copy app link and icon | |
| 360 | -* Added: Bulk actions for views | |
| 361 | -* Added: M:m relation to App Builder | |
| 362 | -* Added: Kill token property to chart widget | |
| 301 | += 5.5.72 = | |
| 302 | +* Released 2026-05-04 | |
| 303 | +* Added: Clear all column filters button to compact vertically placed column filters container | |
| 304 | +* Added: Automatically open column filter list when user opens a column filter in compact mode | |
| 305 | +* Added: Multiple calculation types to table chart | |
| 306 | +* Added: Start app on back-end in fullscreen mode | |
| 307 | +* Added: Default column filter via URL parameter | |
| 308 | +* Added: Plus and minus buttons to numeric input fields | |
| 309 | +* Added: Subtitles to row actions | |
| 310 | +* Added: Rename translation | |
| 311 | +* Fixed: Column filters interfering on tabs | |
| 312 | +* Fixed: Actions column too wide when bulk actions enabled and row actions disabled | |
| 313 | +* Fixed: Removed disabled fields from chart popup (free version only) | |
| 314 | +* Fixed: Resize chart when popup is resized (free version only) | |
| 315 | +* Fixed: Match map and chart popup UIs (free version only) | |
| 316 | +* Fixed: Chart returns an error when no data found | |
| 317 | +* Fixed: Rows not exporting the correct rows when selected with Bulk Select after filtering | |
| 318 | +* Fixed: Table not sorted correctly on lookup column when server-side processing is enabled | |
| 319 | +* Fixed: Removed "number of decimals displayed" if field has no decimals | |
| 320 | +* Fixed: Scheduled queries don't send out attachments if queries are written in uppercase | |
| 363 | 321 | |
| 364 | -= 5.5.4 = | |
| 365 | -* Released 2024-05-28 | |
| 366 | -* Fixed: Lookup values not shown in exports | |
| 367 | -* Fixed: Export to pdf adds an empty column | |
| 368 | -* Fixed: Details not shown to non admin users | |
| 369 | -* Fixed: View action for tables without primary key and views | |
| 370 | -* Fixed: Table cell colors incorrect with multiple apps on one page | |
| 371 | -* Fixed: WordPress media library usage not working on insert | |
| 372 | -* Fixed: Rename view not working | |
| 373 | -* Fixed: Drop view not working | |
| 374 | -* Fixed: Link tooltips in Data Explorer not completely visible | |
| 375 | -* Fixed: Media type update not working | |
| 376 | -* Fixed: Server side updates not synced on client | |
| 377 | -* Fixed: Sending non-updatable fields to server | |
| 378 | -* Fixed: Column filters empty and not empty not working with lookups | |
| 379 | -* Fixed: Column positioning not working with full screen master-detail | |
| 380 | -* Fixed: Reduce margin bottom of error panel in Data Explorer | |
| 381 | -* Added: Alter table action to new Data Explorer | |
| 382 | -* Added: Change PDS refresh interval to new Data Explorer | |
| 383 | -* Added: Manage databases to Data Explorer | |
| 384 | -* Added: Premium Data Services access to new Data Explorer | |
| 385 | -* Added: Change font size of input fields, labels and hints | |
| 386 | -* Added: Monitor updates in App Manager | |
| 387 | -* Added: Refresh columns button to App Manager | |
| 388 | -* Added: Adjustable elevation to app containers | |
| 389 | -* Added: Use WordPress date and time format in tables | |
| 390 | -* Added: Sync root app theme with detail app theme in real time | |
| 391 | -* Added: SQL and ZIP file import to Data Explorer | |
| 392 | -* Added: Bulk actions to Data Explorer | |
| 393 | -* Added: Elevation to Papers, Cards and App Bars | |
| 394 | -* Added: Persistent search criteria in Data Explorer and App Builder | |
| 395 | - | |
| 396 | -= 5.5.3 = | |
| 397 | -* Released 2024-05-15 | |
| 398 | -* Improved: Column filter support | |
| 399 | -* Improved: Several builder hints | |
| 400 | -* Improved: App responsiveness | |
| 401 | -* Fixed: Cannot use view in lookups | |
| 402 | -* Fixed: Master-detail key issue | |
| 403 | -* Fixed: Database column default constraints not used | |
| 404 | -* Fixed: Lookups not used in global search | |
| 405 | -* Fixed: Multi select drop down list not working | |
| 406 | -* Fixed: Position apps list when opening App Builder | |
| 407 | -* Fixed: Error on column filter change | |
| 408 | -* Fixed: Cannot open computed field accordion | |
| 409 | -* Fixed: Column filter between not working | |
| 410 | -* Fixed: JSON parse error in Data Explorer | |
| 411 | - | |
| 412 | -= 5.5.2 = | |
| 413 | -* Released 2024-05-08 | |
| 414 | -* Added: Inherited font family from page | |
| 415 | -* Added: Show more|less button | |
| 416 | -* Added: Column default value | |
| 417 | -* Added: Master-detail display type | |
| 418 | -* Added: Inline HTML support to table cells | |
| 419 | -* Added: Examples to setting blocks | |
| 420 | -* Improved: Relationship configuration | |
| 421 | -* Improved: Lookup configuration | |
| 422 | -* Fixed: Date/time localization not working | |
| 423 | -* Fixed: Prefill parent data in child component | |
| 424 | -* Fixed: Lookup not respecting required constraint | |
| 425 | - | |
| 426 | -= 5.5.1 = | |
| 427 | -* Released 2024-04-19 | |
| 428 | -* Added: 1:1 and 1:n relationships to App Builder | |
| 429 | -* Fixed: Added client version number to prevent caching old client files | |
| 430 | -* Fixed: Geomap not working with block-based themes (Ian) | |
| 431 | -* Updated: Freemius SDK | |
| 432 | - | |
| 433 | -= 5.5.0 = | |
| 434 | -* Released 2024-04-18 | |
| 435 | -* Added: Pre-release new App Builder | |
| 436 | -* Fixed: URL parameter % usage | |
| 437 | - | |
| 438 | -= 5.4.0 = | |
| 439 | -* Released 2024-01-25 | |
| 440 | -* Added: Pre-release new Data Explorer | |
| 441 | -* Added: REST API drop-down multi-select inline search | |
| 442 | -* Added: REST API drop-down inline search | |
| 443 | -* Changed: REST API inline search and estimated row count | |
| 444 | -* Updated: Freemius SDK | |
| 445 | - | |
| 446 | -= < 5.4.0 = | |
| 447 | -* See changelog.txt in plugin folder | |
| 322 | += < 5.5.72 = | |
| 323 | +* See changelog.txt | |
