Advanced features

Posts under the "Advanced features" category

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...

Adding filters

There are three ways to add a filter to a Data Project Default where clause Shortcode parameters URL parameters Default where clauseThe Data Projects tools allow plugin users to add any default where clause to a project page (click image below to enlarge). This...

Advanced lookups

You can use a lookup to create a listbox to select a value from another table. The creation of a lookup is described in the video Data Project Fine Tuning. The plugin used in that video is an older version. Starting from version 3.0.3 you can create lookups to other...

Add less/more button

IMPORTANT Please notice that tab Manage Table Options is no longer available. Table Options was renamed to Project Templates and can now be accessed directly from the plugin menu.

Advanced table options

Topics covered in this video Using multiple options sets Options set hierarchy IMPORTANT Please notice that tab Manage Table Options is no longer available. Table Options was renamed to Project Templates and can now be accessed directly from the plugin menu.

Transfer to other WP site

The Data Projects export was changed in version 3.1.5. You no longer need to export the table options (step 3) separately. Table options will be exported along with the Data Projects definition and pages automatically. If your Data Project uses tables stored in remote...

Managing roles and users

This video tutorial shows how you can use custom roles to give users access to your Data Projects pages in your WordPress dashboard or your web pages using shortcode wpdadiehard.IMPORTANT Please notice that tab Manage Table Options is no longer available. Table...

User roles

A Data Project consists of one or more data administration and/or static pages. You can use the role attribute to give users access to Data Projects pages.Use the $$USER$$ or $$USERID$$ environment variables to get access to the current user:$$USERID$$ >...