Advanced features

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

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

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.

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

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

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.

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

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

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