

Get in touch

Download Plugin Now
  • Follow
  • Follow
WP Data Access
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
    • Tool Guide
    • App Builder
    • Data Explorer
    • SQL Query Builder
    • Plugin Settings
    • Legacy Tools
    • Remote Connections
a
M
M
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
    • Tool Guide
    • App Builder
    • Data Explorer
    • SQL Query Builder
    • Plugin Settings
    • Legacy Tools
    • Remote Connections
Download Plugin Now

App Builder

  • Getting Started
  • App Builder Dashboard
  • Creating your first App
  • Running Apps
  • Export/Import Apps
  • Road Map
  • App Shortcodes
    • Shortcode Usage
    • Shortcode Parameters
    • URL Parameters

App Manager

  • Getting started
  • Supported App Types
  • Supported Languages
  • App Authorization and Access
  • Full-Screen Mode

Table Builder

  • Getting started
  • Relationships
  • Lookups
  • Computed Fields
  • Table
    • Global filter
    • Column filters
    • Bulk Actions
    • Row Actions
    • Column Actions
    • Default where
    • Default Order By
    • Pagination
    • Inline Editing Settings
    • Layout & Responsiveness
      • Responsiveness
      • Density
      • Table Header
      • Table Footer
  • Columns
    • Introduction
    • Column Settings
    • Column Actions
    • Lookup
    • Aggregations
    • Column Metadata
  • Performance
    • Large Table Support
    • Server/Client-Side Processing
  • Filters
    • Global filter
    • Column filters
    • Default where
    • URL parameters
    • Shortcode parameters

Form Builder

  • Getting started
  • Relationships
  • Lookups
  • Computed Fields
  • Form
    • Understanding the Grid
    • Field Layout
    • Column Behaviour
    • Null Value Handling
  • Columns
    • Column Settings
    • Validation
    • Lookup
    • Column Metadata
  • Layout & Behaviour
    • Grid Positioning

Map Builder

  • Getting started
  • Creating a map
  • Using maps

Chart Builder

  • Getting started
  • Creating a chart
  • Using charts

Hooks

  • Getting started with hooks
  • App Hooks
    • global
    • onAppOpen
    • onAppClose
  • Table Hooks
    • customActionsTop
    • customActionsBottom
    • postQuery
    • renderDetailPanel
    • Table Column Hooks
      • render
  • Form Hooks
    • customActionsBottom
    • onRowInit
    • preFormSubmit
    • postFormSubmit
    • Form Column Hooks
      • onBlur
      • onChange
      • onClick
      • onDoubleClick
      • onFocus
      • onKeyDown
      • onKeyUp
  • Built-Ins
    • Overview
    • wpda.log
    • wpda.alert
    • wpda.confirm
    • wpda.snackbar
  • Examples
    • Display specific columns in detail panel
    • Auto-reload table at specific intervals
    • Adding SEO links to table
    • Styling fields with setColumnStyle
    • Hide empty table column
    • Replicate data entered on field into another field

Layout & Styling

  • Fonts
  • Palette
  • Layout
  • Manual Styling (CSS)

Demos

  • Classic Models
  • Student Administration System
  • Data Table

Tutorials

  • Creating a Data Table App
  • Creating a Data Management App
View Categories

Lookups

Lookups need to be set separately in the Table Builder and Form Builder using the Lookup Wizard. In the Table Builder, you can use a lookup to display coherent data values in columns in place of IDs or codes. In the Form Builder, fields with lookups set up are transformed into dropdown fields where you can select appropriate values.

Setting up Lookups #

1. Run & Build your app and open the Table Builder or Form Builder by clicking on the icon.

Table Builder

2. Navigate to the Columns tab and select the column you want to add lookups to. Click on the icon to expand the column and show more column options.

Column Options

3. Click on Lookup to expand the option. A button to start the Lookup Wizard will appear.

The Lookup Wizard #

Click on the Start Lookup Wizard button to show a guided step-by-step on setting up your lookup column.

Lookup Wizard
  1. Select Database – Select the database where your lookup table is located.
  2. Select Table – Select your lookup table.
  3. Select lookup column – Select the lookup column that corresponds to the selected column in your current table.
  4. Select lookup column values – Select which column contains the column value you wish to display. You can choose more than one column for column values. A column delimiter field allows you to add any symbol to serve as a value separator.
  5. Lookup conditions (optional) –
    • Default WHERE clause – You can add a Default WHERE clause if you wish to apply the lookup on specific values only. You can leave this field empty if no conditions are needed.
    • Dynamic Conditions – In the Form Builder and if inline editing is enabled for columns in the Table Builder, you can update the lookup of another field based on the conditions set here.
  6. Load full lookup on startup – Enabling this option helps lookup entries load faster when users interact with your app.

Updating Lookups #

To update a lookup, simply click on the Update button. This will let you go through the steps again from the start.

Deleting Lookups #

To delete a lookup, click on the Delete button. A prompt will display to let you confirm the action. You need to click on APPLY for the deletion to take effect and then click OK.
Share This Article :
  • Facebook
  • X
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on 2025-02-10
Computed Fields

Submit a Comment Cancel reply

Your email address will not be published. Required fields are marked *

Table of Contents
  • Setting up Lookups
  • The Lookup Wizard
  • Updating Lookups
  • Deleting Lookups
WP Data Access
  • Follow
  • Follow
Quick Links
$

Blogs

$

Tutorials

$

Demos

Get in touch
$

Premium support

$

Free support forum

$

Contact us

Resources


WordPress plugin directory



YouTube tutorials

Copyright © 2025 | All Right Reserves

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok