PluginProbe
WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards / 5.5.23
WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards v5.5.23
5.5.83 5.5.82 5.5.81 5.5.80 5.5.79 5.5.77 5.5.76 5.5.75 5.5.73 5.5.72 5.5.22 5.5.23 5.5.29 5.5.3 5.5.31 5.5.32 5.5.34 5.5.35 5.5.36 5.5.37 5.5.4 5.5.40 5.5.41 5.5.42 5.5.43 All 159 releases
wp-data-access / readme.txt

readme.txt in WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards 5.5.23, at readme.txt

474 lines 22.3 KB
No matching file
Up and down to move Enter to open Esc to close
Raw Download Zip
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.23
7 License: GPLv2 or later
8 License URI: http://www.gnu.org/licenses/gpl-2.0.html
9
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
12 == 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
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.
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
39
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**.
42
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**
50
51 == SQL Query Builder ==
52 > **Run SQL queries directly within WordPress.**
53
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/)
58
59 == Premium Data Services ==
60 > **Effortlessly connect, sync, and manage remote databases and data files.**
61
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)
66
67 == Plugin Settings ==
68 > Detailed settings for **managing the user interface and behavior**.
69
70 * Tailor your experience with a wide range of detailed settings to control both the user interface and functionality of the plugin
71
72 == Legacy Tools ==
73 > Soon replaced by the **App Builder**.
74
75 * Available until at least summer 2025
76 * Use to maintain old solutions
77 * Use **App Builder** for new projects
78
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 == Useful Links ==
97 - [Plugin Website](https://wpdataaccess.com/)
98 - [Documentation](https://wpdataaccess.com/documentation/)
99
100 == Installation ==
101 (1) Upload the WP Data Access plugin to your WordPress site
102 (2) Activate the plugin
103 (3) Navigate to the WP Data Access menu
104
105 And you're all set!
106
107 == Changelog ==
108
109 = 5.5.23 =
110 * Released 2024-12-18
111 * Added: Enable|disable embedded HTML in text columns
112 * Added: Customizable height for multi line text fields
113 * Added: Default user adjustable column filter value
114 * Fixed: Cannot save legacy tool status with free version
115 * Fixed: Lovs not unescaping HTML characters
116 * Fixed: Lookups not unescaping HTML characters
117 * Fixed: Input font sizing not working
118 * Fixed: When adding a new row, dropdown fields that set to be non-editable or hidden still appear visible and editable
119 * Fixed: Date localization UK not working correctly
120 * Fixed: Selection checkboxes visibility not toggled when fullscreen toggled
121 * Fixed: Plain text hyperlink not processed correctly
122 * Fixed: App type search not working when text search is empty
123 * Fixed: Form not showing if default where contains error
124 * Fixed: Give a proper console error when table lookup fails
125 * Fixed: 1:1 relationship issues
126 * Fixed: Search & replace gives no results for remote databases
127 * Fixed: Invalid hyperlink format throws error and shows blank screen
128 * Fixed: Change order direction handling
129 * Changed: Builder menu structure to accommodate more menu items
130 * Changed: Math library to reduce bundle size
131 * Optimized: Client bundle
132 * Optimized: Store handling
133 * Optimized: Lazy load language files
134 * Updated: Freemius SDK
135
136 = 5.5.22 =
137 * Released 2024-11-28
138 * Added: Table component reference to table hooks
139 * Added: Parameter pp-page to jump to specific page on page load
140 * Added: Allow inline editing with row update disabled
141 * Added: Save button to table header for inline updates
142 * Added: Hide auto-increment columns during insert if visibility = off
143 * Fixed: Missing form column code causes fatal error
144 * Fixed: WPDAVAR and WDPATMP no longer working in SQL Query Builder
145 * Fixed: Insert fails when primary key contains and auto_increment and additional columns
146 * Fixed: Global search not working in free version
147 * Fixed: Less than character not unescaped
148 * Fixed: Lookup wizard update does not update related tables and columns
149 * Changed: Freemius SDK integration
150 * Optimized: Bundles and store
151
152 = 5.5.20 =
153 * Released 2024-11-15
154 * Fixed: Apply + OK buttons not working after closing Form Builder
155 * Fixed: Null value validation not triggered on update
156 * Fixed: All legacy tools removed from toolbar
157
158 = 5.5.19 =
159 * Released 2024-11-15
160 * Added: Enable | Disable legacy tools from tool guide page
161 * Added: Allow server side default values on insert
162 * Moved: Dashboards and Charts menu items to legacy tools section
163 * Fixed: Tool guide header too wide on small devices
164 * Fixed: Hidden elements using dashboard space
165 * Fixed: Trailing comma causing error with PHP7
166 * Fixed: Selector returns different results when called with same arguments
167 * Fixed: Join Builder and Relation Builder button access
168
169 = 5.5.17 =
170 * Released 2024-11-07
171 * Added: Charts to App Builder
172 * Added: Rename database feature
173 * Added: Allow computed fields in forms as own element (instead of inside an input element)
174 * Added: Tip to improve performance on first table load
175 * Improved: Usability builder column icons
176 * Fixed: Pagination issue, next button not clickable on second page
177 * Fixed: Fields with inline editing enabled reflect first row value when second row is filtered
178 * Fixed: Column header to wide when inline search in header is enabled
179 * Fixed: Default full screen not defined
180 * Fixed: Row count issue with large table support
181 * Fixed: Missing mandatory column does not show error on insert
182 * Fixed: Passing incorrect form mode
183 * Fixed: Disable inline editing for parent ID column
184 * Fixed: Populating M2M list returns unknown column in field list
185 * Fixed: Insert M2M form using auto increment column
186 * Fixed: Lookup relation tables returning bad request
187 * Fixed: Mandatory columns not in forms prevent saving data
188 * Updated: Freemius SDK
189
190 = 5.5.16 =
191 * Released 2024-10-16
192 * Added: Registration form
193 * Added: Save view selection in App Builder
194 * Added: Cascading app deletion
195 * Added: Allow user to show | hide table columns
196 * Optimized: Hook editor updates to prevent unnecessary re-renders
197 * Changed: Bulk action column selection showing labels instead of column names
198 * Fixed: Join and relation table settings not saved correctly
199 * Fixed: Class names for styles not applied to lookup fields
200 * Fixed: XML export not processing null values correctly
201 * Fixed: App copy missing multi-level relationships
202 * Fixed: App export missing multi-level relationships
203 * Fixed: App export missing WordPress table prefix
204 * Fixed: App copy Data App missing detail apps
205 * Fixed: App export Data App missing detail apps
206 * Fixed: Responsiveness of data tables also set to scroll for views
207 * Fixed: Column filter layout when field layout is filled
208 * Fixed: Default detail panel overflow on mobile devices
209 * Fixed: Media button labels in Form Builder DELETE and SELECT not translated
210 * Fixed: Disable column render hook for computed fields
211 * Fixed: Border radius first line App Builder and Data Explorer incorrect
212 * Fixed: Color button labels in header
213 * Fixed: Border radius incorrect App Builder and Data Explorer
214 * Fixed: Null pointer exception on toLowerCase
215 * Fixed: Handle references to deleted apps
216 * Fixed: Cannot open table builder for data explorer
217 * Fixed: Show more button relation table
218 * Fixed: Cleanup relation table references on cancel
219 * Fixed: Column filter processing join and relation table columns
220 * Fixed: App crashes when filter is changed on detail table
221 * Fixed: Special characters added to column label end are moved to the front in detail view
222 * Fixed: Searchbox highlight replicating selected values
223 * Fixed: Last column disappears when it is invisible and a computed field is added
224 * Removed: Refresh icon from table table when inline editing is enabled
225 * Removed: Copy/export data apps (copy only real containers)
226 * Removed: Redundant free code from premium version (does not affect free version)
227 * Updated: Opt-in icons
228 * Updated: Freemius SDK
229
230 = 5.5.14 =
231 * Released 2024-09-17
232 * Added: Manage relationships from Table Builder and Form Builder
233 * Added: Selectable density state to App Builder and Data Explorer
234 * Added: Force aggregations to use column localization settings
235 * Added: Start apps in full screen mode
236 * Fixed: Reapply theme settings to app after switching
237 * Fixed: App Builder record lists subtract 1 day from date fields
238 * Fixed: Fatal error when disabling full lookup on startup
239 * Fixed: Column border missing in table and form builder
240 * Fixed: Lookup value substitution not working correctly when lookup return just one value
241 * Fixed: Computed field duplicated when applied multiple times on creation
242 * Fixed: Menu item not focusable
243 * Fixed: Row selection checkbox shown above row action icons when scrolling
244 * Fixed: Hidden columns shown when responsiveness is set to scrollbar
245 * Changed: Row selection column no longer pinned
246 * Changed: Show icon buttons on toolbar instead of buttons on small devices
247 * Changed: App Builder layout
248 * Updated: Freemius SDK
249
250 == Changelog ==
251 = 5.5.13 =
252 * Released 2024-09-08
253 * Fixed: Events on computed fields lost
254 * Fixed: Textarea padding
255 * Fixed: Responsive column hiding
256 * Fixed: Padding right TH, TD
257 * Fixed: Table overflow issues
258
259 = 5.5.12 =
260 * Released 2024-09-05
261 * Fixed: Relation table not shown when using artificial primary key
262 * Fixed: Relation table join condition missing table names
263 * Fixed: Date not localized
264 * Fixed: Explicitly set background fixed columns
265 * Fixed: Removed migration message from Data Designer toolbar
266 * Fixed: Auto complete internal key mismatch
267 * Fixed: Image size in data table
268 * Added: Export to PDF icon to detail panel
269 * Added: Column selection in bulk actions exports
270 * Added: A number of hooks to customize data table layout and behaviour
271 * Changed: Detail panel layout
272 * Changed: App Builder layout
273 * Changed: Data Explorer layout
274
275 = 5.5.11 =
276 * Released 2024-08-22
277 * Fixed: Super admin cannot access sub site
278 * Fixed: Divi styling issues
279 * Fixed: Elementor styling issues
280 * Fixed: Cannot read properties of null (reading 'toLocaleLowerCase')
281 * Fixed: Full screen data app not showing table correctly
282 * Fixed: Inline auto save columns not saving properly
283 * Fixed: Cannot use % character in where clause lookups
284 * Fixed: Pagination rows per page setting not updated
285 * Fixed: M:M relationships losing primary key values
286 * Added: View Data Apps structure in App Builder
287 * Added: Copy shortcode to App Builder actions
288 * Added: App actions menu to the App Builder
289 * Added: Pagination display options: top, bottom, or both
290 * Added: Support for thousand and decimal separators in numeric input fields
291 * Added: Enhanced language support for date, time, and numeric fields
292 * Added: CodeMirror integration for writing computed field implementations
293 * Added: JavaScript and HTML support to Code Mirror
294 * Added: Hint to old table and form builders to prevent confusion
295 * Added: Inline data viewing with a detail panel
296 * Added: WordPress and plugin table information to the Data Explorer
297 * Changed: Builder resizing behaviour
298 * Removed: View row id from data table
299 * Removed: App foreign key constraints
300 * Updated: Freemius SDK
301
302 = 5.5.9 =
303 * Released 2024-07-30
304 * Fixed: Localization not available for date columns
305 * Fixed: Increase specificity table style
306 * Fixed: Form Builder icon always visible for master-detail relationships
307 * Fixed: Highlighting not working if inline HTML is enabled
308 * Fixed: React findDOMNode is deprecated in StrictMode
309 * Fixed: Invalid data type on column filter
310 * Fixed: Cannot reorder details
311 * Fixed: Cannot add column filter for hidden columns
312 * Fixed: Relationship display type updates not detected
313 * Fixed: App Manager asking for confirmation after shortcode generation
314 * Fixed: Inline field settings not applied
315 * Fixed: Undefined table settings on multi level master-detail
316 * Fixed: App pages on back-end missing CSS styling
317 * Moved: Changelog to readme (making it available online)
318 * Added: New app type "app container" to bundle apps into one main app
319 * Added: Apps to repository backup and restore
320 * Added: Tool replacement info.
321 * Added: Premium color gold to plugin menu icon.
322 * Added: Tool guide page also containing FAQs
323 * Added: Let import container wait until all databases are loaded
324 * Added: Added lookup placeholders to computed fields
325 * Added: Custom shortcode parameter support
326 * Added: Make computed field label in Form editable from columns list
327 * Added: Container ID to increase CSS specificity
328 * Added: Classname pp-fullscreen to body element when entering full screen mode
329
330 = 5.5.7 =
331 * Released 2024-07-16
332 * Fixed: Adding a search pane to a column with lookup requires a full table reload
333 * Fixed: Page scrolls down when keys f, s, t, v pressed in search boxes
334 * Fixed: Autocomplete not correctly showing for lookup columns with field layout set to filled or standard
335 * Fixed: Null value in LOV returns an empty list item
336 * Fixed: Filter mode 'between inclusive' for datetime not working correctly (same results as inclusive)
337 * Improved: Language files loaded moved to JSON format and loaded at runtime to improve performance
338 * Improved: Many textual improvements (hints, examples, labels)
339 * Improved: Uniformized layout and style of all field types and modes
340 * Improved: Computed field calculations and display
341 * Added: Several CSS classes for custom styling
342 * Added: Customize column filters width
343 * Added: Customize column filters ordering
344 * Added: Customize default page size
345 * Added: Customize available page sizes
346 * Added: Search panes
347 * Added: Cascading searches for lookups and lovs
348 * Added: Custom color picker to theme settings
349 * Added: HTML and JS support to computed fields
350 * Added: URL parameter support
351 * Added: Shortcode parameter support
352 * Added: Ability to disable full screen mode
353 * Added: Workaround for app preview not loading styles in Divi Visual Builder (showing no preview message instead)
354 * Updated: Freemius SDK
355
356 = 5.5.6 =
357 * Released 2024-07-02
358 * Fixed: Lookup search
359 * Fixed: User can hide column filter by clicking on filter icon even when hiding is disabled
360 * Fixed: Filter match highlight
361 * Added: Shortcode parameter to disable builders on front-end
362 * Added: Show column filters in table column header
363 * Added: Lookups missing to export
364 * Added: Computed fields to export
365 * Added: Filter match highlight to lookup columns
366 * Added: Column alignment to PDF export
367 * Added: PDF orientation and style selection
368 * Added: Full app localization (containing 35 languages)
369 * Added: Export apps
370 * Updated: Freemius SDK
371
372 = 5.5.5 =
373 * Released 2024-06-20
374 * Post fix: Copy app not copying details
375 * Post fix: New record added twice for m:m relationship
376 * Fixed: Force user to select at least one column on app creation or update
377 * Fixed: Force user to select at least one column on lookup creation or update
378 * Fixed: Force user to select at least one column on relationship creation or update
379 * Fixed: Plugin does not register lookup changes
380 * Fixed: Empty detail blocks visible on master insert
381 * Fixed: Wrong (local) date in data table (converted to UTC)
382 * Fixed: Row selection toggled on inline editing fields
383 * Fixed: Builder buttons on detail form visible to non admins
384 * Fixed: Media Library window appears behind the form when triggered
385 * Changed: Export table or app name instead of app id
386 * Added: Copy app link and icon
387 * Added: Bulk actions for views
388 * Added: M:m relation to App Builder
389 * Added: Kill token property to chart widget
390
391 = 5.5.4 =
392 * Released 2024-05-28
393 * Fixed: Lookup values not shown in exports
394 * Fixed: Export to pdf adds an empty column
395 * Fixed: Details not shown to non admin users
396 * Fixed: View action for tables without primary key and views
397 * Fixed: Table cell colors incorrect with multiple apps on one page
398 * Fixed: WordPress media library usage not working on insert
399 * Fixed: Rename view not working
400 * Fixed: Drop view not working
401 * Fixed: Link tooltips in Data Explorer not completely visible
402 * Fixed: Media type update not working
403 * Fixed: Server side updates not synced on client
404 * Fixed: Sending non-updatable fields to server
405 * Fixed: Column filters empty and not empty not working with lookups
406 * Fixed: Column positioning not working with full screen master-detail
407 * Fixed: Reduce margin bottom of error panel in Data Explorer
408 * Added: Alter table action to new Data Explorer
409 * Added: Change PDS refresh interval to new Data Explorer
410 * Added: Manage databases to Data Explorer
411 * Added: Premium Data Services access to new Data Explorer
412 * Added: Change font size of input fields, labels and hints
413 * Added: Monitor updates in App Manager
414 * Added: Refresh columns button to App Manager
415 * Added: Adjustable elevation to app containers
416 * Added: Use WordPress date and time format in tables
417 * Added: Sync root app theme with detail app theme in real time
418 * Added: SQL and ZIP file import to Data Explorer
419 * Added: Bulk actions to Data Explorer
420 * Added: Elevation to Papers, Cards and App Bars
421 * Added: Persistent search criteria in Data Explorer and App Builder
422
423 = 5.5.3 =
424 * Released 2024-05-15
425 * Improved: Column filter support
426 * Improved: Several builder hints
427 * Improved: App responsiveness
428 * Fixed: Cannot use view in lookups
429 * Fixed: Master-detail key issue
430 * Fixed: Database column default constraints not used
431 * Fixed: Lookups not used in global search
432 * Fixed: Multi select drop down list not working
433 * Fixed: Position apps list when opening App Builder
434 * Fixed: Error on column filter change
435 * Fixed: Cannot open computed field accordion
436 * Fixed: Column filter between not working
437 * Fixed: JSON parse error in Data Explorer
438
439 = 5.5.2 =
440 * Released 2024-05-08
441 * Added: Inherited font family from page
442 * Added: Show more|less button
443 * Added: Column default value
444 * Added: Master-detail display type
445 * Added: Inline HTML support to table cells
446 * Added: Examples to setting blocks
447 * Improved: Relationship configuration
448 * Improved: Lookup configuration
449 * Fixed: Date/time localization not working
450 * Fixed: Prefill parent data in child component
451 * Fixed: Lookup not respecting required constraint
452
453 = 5.5.1 =
454 * Released 2024-04-19
455 * Added: 1:1 and 1:n relationships to App Builder
456 * Fixed: Added client version number to prevent caching old client files
457 * Fixed: Geomap not working with block-based themes (Ian)
458 * Updated: Freemius SDK
459
460 = 5.5.0 =
461 * Released 2024-04-18
462 * Added: Pre-release new App Builder
463 * Fixed: URL parameter % usage
464
465 = 5.4.0 =
466 * Released 2024-01-25
467 * Added: Pre-release new Data Explorer
468 * Added: REST API drop-down multi-select inline search
469 * Added: REST API drop-down inline search
470 * Changed: REST API inline search and estimated row count
471 * Updated: Freemius SDK
472
473 = < 5.4.0 =
474 * See changelog.txt in plugin folder