Docs

Posts under the "Docs" category

Lookup Wizard

This section is still being updated. Some information might be incomplete. If you have any questions, feel free to drop us a message here. Lookups are now available to all app types and need to be set separately in the Table Builder and Form Builder. In the Table...

Form Builder

This section is still being updated. Some information might be incomplete. If you have any questions, feel free to drop us a message here. The Form Builder is where you can customize your app's form functions. On this page, you can set up relationships and lookups to...

Table Builder

This section is still being updated. Some information might be incomplete. If you have any questions, feel free to drop us a message here. The Run & Build button opens to a table view of your app. On this page, you can set up your table according to your...

App Types

This section is still being updated. Some information might be incomplete. If you have any questions, feel free to drop us a message here. There are currently two app types available to choose when creating apps for your database tables, a Data Table app which is...

What’s the App Builder?

This section is still being updated. Some information might be incomplete. If you have any questions, feel free to drop us a message here. The App Builder is a new way to build data tables and data administration apps from your database tables. It offers more features...

Creating A New App

This section is still being updated. Some information might be incomplete. If you have any questions, feel free to drop us a message here. To create your first app, start by clicking on the Create New App icon in the upper right corner of the page. This opens the App...

The App Builder Dashboard

This section is still being updated. Some information might be incomplete. If you have any questions, feel free to drop us a message here. Apps Button - Click on this button on the toolbar to access the App Builder Dashboard. Create New App - Opens the App Builder...

Manage App Toolbar

This section is still being updated. Some information might be incomplete. If you have any questions, feel free to drop us a message here. The Manage App toolbar can be accessed by clicking the ⚙ icon on the right or by hovering over your app and clicking the "Manage"...

Environment variables

The following environment variables can be used in WP Data Access $$USERID$$ WordPress user ID $$USER$$ WordPress user login $$EMAIL$$ WordPress user email $$NOW$$ Current date $$NOWDT$$ Current date + time Environment variables can be used As default values in...

WordPress user ID in SQL

WP Data Access adds a session variable containing the WordPress user ID to its database connections. This allows plugin users to access the WordPress user ID in SQL queries, database views, triggers, functions and procedures.Open the Query Builder and enterThis...