WP Data Access

Skip to content

WP Data AccessApp Builder

Main Navigation

WP Data Access Home

WordPress Plugin Directory

Support

Premium Support

Documentation

SQL Query Builder

Remote Connections

Plugin Settings

Appearance

Sidebar Navigation

Getting Started

Getting Started - Video Tutorial

App Wizard - Creating Apps

App Builder - Building Apps

App Manager - Running Apps

Supported App Types

Supported Languages

Transferring Apps

WordPress user ID in SQL

App Wizard

Getting Started

Step 1 - App Info

Step 2 - Data Source | Apps

Step 3 - Access

App Manager

Getting Started

Index 🔎

App Manager Menu

Overview

App Info

Data Source | Apps

Access

Running Apps

Running apps on the back-end

Running apps on the front-end

Shortcodes

Shortcode Usage

Shortcode Parameters

URL Parameters

Table Builder

Getting Started

Index 🔎

Table Builder Menu

Overview

Table

Overview

Performance

Relationships

Global Filter

Column Filters

Detail Panel

Bulk Actions

Row Actions

Column Actions

Default Where

Default Order By

Pagination

Layout & Responsiveness

Cache & Token Settings

CSS Table Editor

Inline Editing Settings

Columns

Overview

Column Settings

Column Actions

Lookups

Aggregations

Column Metadata

Computed Fields

Maps

Charts

Hooks

Theme

Form Builder

Getting Started

Index 🔎

Form Builder Menu

Overview

Form

Overview

Relationships

Navigation and Apply Buttons

Grid

Cells

Field Layout

Field Spacing

Null Value Handling

Columns

Overview

Grid Positioning

Column Settings

Validation

Lookup

Column Metadata

Computed Fields

Hooks

Theme

Map Builder

Getting Started

Map Builder Menu

Overview

Map

Overview

Setup

Initial Location

User Interaction

Marker Layout

Default Where

Theme

Chart Builder

Getting Started

Supported Chart Types

Bar Chart

Column Chart

Histogram

Line Chart

Area Chart

Pie Chart

Gauge

Table

Chart Builder Menu

Overview

Chart

Overview

Setup

Chart Types

Settings

Title & Legend

Colors

Axis

Chart Area

User Interaction

Custom Options

Custom Events

Theme

Dashboard Builder

Getting Started

Dashboard Builder Menu

Overview

Dashboard

Overview

Dimension

Layout

Dashboard CSS Editor

Grid CSS Editor

Theme

Widget Settings

Overview

Configuration

Dimension

Layout

Widget CSS Editor

Widgets Drag-And-Drop

Hooks

Getting Started

App Hooks

global

onAppOpen

onAppClose

Table Hooks

customActionsTop

customActionsBottom

postDelete

postQuery

preDelete

renderDetailPanel

Table Column Hooks

render

Form Hooks

customActionsBottom

onFormClose

onFormOpen

onRowInit

postFormSubmit

postInsert

postUpdate

preFormSubmit

preInsert

preUpdate

Form Column Hooks

onBlur

onChange

onClick

onDoubleClick

onFocus

onKeyDown

onKeyUp

Built-ins

Getting Started

Namespace wpda

wpda.log.[level]()

wpda.alert()

wpda.button()

wpda.callService()

wpda.confirm()

wpda.snackbar()

Context Object app

app.getUsername()

app.userHasRole()

app.setGlobalSearch()

app.setColumnFilters()

app.setInsert()

app.setUpdate()

app.setDelete()

app.setInlineEditing()

app.setBulkActions()

Name Functions

getColumnValue()

setColumnValue()

setColumnStyle()

setColor()

setBackgroundColor()

setRowColor()

setRowBackgroundColor()

setValidationError()

unsetValidationError()

loadScript()

loadStyle()

Dynamic Permission Control

Client-Side

Server-Side

Examples

Adding a Lightbox

Adding Event Listeners

Manage App Settings

Manage App Permissions

Custom Detail Panel

Reload page after form submit

Auto-reload at specific intervals

Adding SEO links to table

Styling fields with setColumnStyle

Hide empty table column

Replicate field data

Layout and Styling

Getting Started

Font

Palette

Layout

Manual Styling with CSS

On this page

🚀 Rapid Application Development with the App Builder

🔍 Database

Select the database where your table is located.
The dropdown updates dynamically based on available connections.

Pager

Next pageGetting Started