Table and column definitions are used to generate list tables and data entry forms. Constraints are handled internally by the plugin. Additional constraints can be added using database triggers. Make sure to handle errors correctly in your database triggers. This...
Data Apps
Posts under the "Data Apps" category
Tutorials
Projects and templatesDynamic lookupsOne to many relationshipsMany to many relationshipsUsing multiple table options setsUser roles and where clausesManaging user rolesTransfer to other website
Demos
Data Forms
Data Forms turns your Data Projects into state of the art responsive data apps. It uses jQuery DataTable with server side processing to handle large amounts of data. Data entry forms are generated using AngularJS. Existing Data Projects can be executed as Data Forms...
Project Templates
Project Templates are used to customize Data Projects pages. Without a template the plugin uses the default values for all page items. A template contains five sections to customize table layout and behaviour. Each section can be managed individually.Every project...
Data Projects
Data Projects is a tool that allows plugin users to build data management pages for back-end and front-end usage. Projects are table based. Pages are generated on the fly. Database constraints and triggers are integrated automatically. Transaction levels can be added...
Custom validation
WP Data Access supports custom validation through JavaScript and database triggers. JavaScript validation is very simple, just add a JavaScript function named pre_submit_form() to your page which handles the validation. The plugin will automatically execute your...
Front-end toolbar
Data Projects added to the users dashboard menu are automatically added to the front-end toolbar as well.ExampleChange settingsDisable "Add projects to toolbar" in Front-end setting if you don't want to show project menu items in the front-end toolbar.Note Add to menu...
Creating templates
To create a new template: Click on the Data Templates menu item Click on button Add Project Template To Repository Select the database and table Click on button Add Template For Selected Table To Repository This will create a template for the selected table....
Reconcile
When a table or its settings have changed, the templates for that table have to be synced. If a new column is added to a table for example, the template needs to be updated to use the new column. If the column is not required, the template will continue to work. It...
Recent Comments