WP Data Access
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
Select Page
Popular Search importsqlformqueryexport

WP Data Access

  • Getting started
  • Installation
  • What’s new?
  • Patches
  • Known limitations
  • FAQ

Data Tables

  • Getting Started
  • Creating and publishing
  • Responsive data tables
  • SEO friendly data tables
  • Adding hyperlinks
  • Extension Manager
  • Style Manager
  • Language settings
Styling
  • Style Manager
  • Premium styling
  • Global styling
  • Code Manager Styling
  • Manual styling
  • Styling issues
Filters
  • Static filters
  • Interactive filters
    • URL parameters
    • Search Panes
    • Search Builder
    • Search form
    • Advanced search
    • Geolocation search
Export & other buttons
  • Export to PDF, CSV, Excel, SQL
  • Print & copy buttons
  • Column selection buttons
  • Custom buttons
Advanced features
  • Advanced settings
  • Large tables & performance
  • Progressively SHOW MORE
  • Custom queries
  • Custom Post Types
  • Row grouping
  • Responsive master-detail
  • Master-detail tables
  • Non admin user access
Demos & tutorials
  • Demos
  • Tutorials

Data Apps

  • Data Projects
  • Projects and templates
  • Supported Data Types
  • One-To-Many relationships
  • Many-To-Many relationships
  • Registration page
  • Manage table options
  • Shortcode usage
Project Templates
  • Project Templates
  • Creating templates
  • Table Settings
  • Relationships
  • List Table
  • Data Entry
  • Reconcile
Data Forms
  • Data Forms
  • Overview
  • Project Demo
  • Page Demo
Advanced features
  • Adding filters
  • Custom validation
  • Add less/more button
  • User roles
  • Managing roles and users
  • Advanced table options
  • Advanced lookups
  • Front-end toolbar
  • Transfer to other WP site
Demos & tutorials
  • Demos
  • Tutorials

Data Explorer

  • Getting started
  • Navigation
  • Explore tables & views
  • Manage tables & views
  • Naming conventions
Manage Actions
  • Actions
Manage Settings
  • Settings
  • Search Settings
  • Geolocation Settings
  • Table Settings
  • Column Settings
  • Dynamic Hyperlinks
  • Dashboard Menus
Data Management
  • Import CSV & SQL files
  • Run SQL script files
  • Data Backup
Problems & solutions
  • InnoDB #rows estimation
  • Import file too large
  • Transfer to other WP DB

Remote Databases

  • MySQL | MariaDB
Other DBMS
  • Heterogeneous Connections
  • Using ODBC | JDBC
  • Connect to SQL Server
Premium Data Services
  • Remote wizard
  • START HERE
  • Errors and messages
  • Limitations
  • Tutorials
  • Remote Databases
    • Remote databases
    • SQL Server
    • PostgreSQL
    • Oracle
    • MariaDB | MySQL
    Remote Data Files
    • Remote data files
    • CSV files
    • JSON files
    • MS Access
    • XML files
    • Public URL
    • Synchronization
    Advanced features
    • Performance
    • Indexes

SQL

  • Getting Started
  • Tutorials
  • Visual Query Builder
  • Writing queries
  • Data exchange
  • Stored procedures
  • Database triggers
  • Scheduled queries

Business Intelligence

  • Getting started
  • Dashboards
  • Sharing dashboards
Dashboards Widgets
  • Dashboard Widgets
  • Publication Widget
  • Project Widget
  • Chart Widget
  • Custom Code Widget
  • Database Widget
  • Sharing Widgets

Table Design

  • Getting started
  • Introduction
  • Basic mode

Plugin Settings

  • Getting started
  • Plugin
  • Back-end
  • Front-end
  • Dashboard
  • Data Forms
  • Data Tables
  • Data Backup
  • Uninstall
  • Manage Repository
  • Manage Roles
  • System Info

Code

Shortcodes
  • Overview
  • wpdataaccess
  • wpdadataproject
  • wpdadataforms
  • wpdadiehard
  • wpdageomap
  • wpdawidget
Hooks & filters
  • Overview
  • Hooks
    • Overview
    • wpda_add_search_actions
    • wpda_add_search_filter
    • wpda_before_list_table
    • wpda_after_list_table
    • wpda_wpdataaccess_prepare
    Filters
    • Overview
    • wpda_column_default
    • wpda_before_simple_form
    • wpda_after_simple_form
    • wpda_construct_where_clause
API
  • WP Data Access API
  • Remote database access
  • CRUD Example
  • Extensions
    • Alternative search algorithm
    • Alternative buttons extension
Code Manager
  • Overview
  • Write code
  • Share(d) code

Column Settings

Table of Contents
  • Column Labels
  • Column Types
    • WordPress Media Library integration
      • Attachments
      • Audio
      • Hyperlink
      • Image
      • Image URL
      • Video
      • Multiple and single media columns
      • Column format examples
    • Notes
  • Inline editing
    • Inline editing example
    • Inline editing – text and numeric columns
    • Inline editing – date and time columns
    • Inline editing – checkboxes
    • Inline editing – drop-down lists
    • Inline editing – lookups (Data Projects only)
  • Inline editing limitations

WP Data Access > Data Explorer > Manage > Settings > Column Settings

  • Column labels
  • Column types (images, audio, video, attachments, hyperlinks)
  • Inline editing (edit table data in an Excel like manner)

Column Labels #

Column labels are automatically used throughout the plugin in all list tables and data entry forms (Data Explorer, Data Tables and Data Projects). Within Data Tables and Data Projects column labels can be overwritten.

There are two types of column labels:

  1. Column labels for list tables
  2. Column labels for data entry forms
If you do not define any column labels for a table or view, the default label settings will be used.

Column Types #

WP Data Access - Data Explorer Column types

WordPress Media Library integration #

The plugin supports WordPress media library integration for column types:

  • Attachment
  • Audio
  • Hyperlink
  • Image
  • Image URL
  • Video

These columns will be handle as media columns throughout the plugin, including list tables, data entry forms, Data Tables pages and Data Project pages.

Attachments #

Attachment columns can store any media from your WordPress media library. In a list table an attachment is shown as a link to the associated file. Media can be added in a data entry form in edit mode. In view mode the attachment is shown as a hyperlink.

Audio #

Audio columns can only store audio from your WordPress media library. The plugin generates an audio shortcode for this type of media in list tables. Audio can be added in a data entry form in edit mode. In view mode an audio shortcode is added to the form.

Hyperlink #

Stores a static hyperlink in JSON or TEXT format (see Table Settings for more information). The hyperlink can be entered in the data entry form of the table and is shown as a hyperlink in list tables and data tables.

Image #

Image columns can only store images from your WordPress media library. The plugin generates an img tag for this type of media in list tables. Images can be added in a data entry form in edit mode. In view mode, an img tag is added to the form.

Image URL #

Stores a static image URL. The URL can be entered in the data entry form of the table and is shown as an image in list tables and data tables.

Video #

Video columns can only store video from your WordPress media library. The plugin generates a video shortcode for this type of media in list tables. Video can be added in a data entry form in edit mode. In view mode, a video shortcode is added to the form.

Multiple and single media columns #

The plugin supports multiple as well as single media columns:

  • NUMBER columns are handled as single media columns
  • VARCHAR columns are handled as multiple media columns

Single media columns can only save only one media id. Multiple media columns can save as many media IDs as you like. The width of your char column determines the maximum number of IDs that can be stored. Make sure your column is wide enough!

Column format examples #

  • column “bike_photo bigint(20) unsigned” can store one image or attachment
  • column “bike_attachments varchar(200)” can store multiple images or attachments until there is no more space left

Notes #

  • The association with the WordPress media library will only work within the plugin!
  • Data entry for media columns is only available within the WordPress dashboard. Shortcode usage on web pages offers support for WordPress media columns in list tables only.

An line example of a data table using WordPress media library integration for an Attachment and an Image column is shown below.

BrandBrand TypeColorPhotoAttachmentsPriceLicence PlateCategoryFuel TypeMileageEngine CapacityNo Cylinders
BrandBrand TypeColorPhotoAttachmentsPriceLicence PlateCategoryFuel TypeMileageEngine CapacityNo Cylinders

Inline editing #

Inline editing is a premium feature that allows users to edit table data in an Excel-like manner. Adding inline editing to a table column is as simple as enabling the “Edit” checkbox as shown on the image below (click to enlarge). How inline editing is handled depends on the column type.

WP Data Access - Data Explorer Column Setting - Inline Editing

Inline editing example #

WP Data Access premium - Inline editing demo

Inline editing – text and numeric columns #

These column types are handled as normal text and numeric columns. The input item contains an icon to save and an icon to revert changes (see images below). A numeric check is performed for numeric columns.

WP Data Access - Data Explorer Inline Editing - text
WP Data Access - Data Explorer Inline Editing - numeric

Inline editing – date and time columns #

Date and time columns can be entered using the date time picker which is available for data entry forms as well.

WP Data Access - Data Explorer Inline Editing - date

Inline editing – checkboxes #

Like in plugin data entry forms, columns of data type tinyint(1) are converted to a checkbox, which provides a natural enable/disable user interface.

WP Data Access - Data Explorer Inline Editing - checkbox

Inline editing – drop-down lists #

Columns of data type enum are converted to drop-down lists (see column Gender in example below). Columns of data type set are converted to drop-down lists that allow multiple selections (see column Multilist in example below).

WP Data Access - Data Explorer Inline Editing - list

Inline editing – lookups (Data Projects only) #

When inline editing is enabled on a lookup column in a Data Project, the plugin automatically generates a listbox for the lookup column.

WP Data Access - Data Explorer Inline Editing - lookup

Inline editing limitations #

  • Inline editing is not available for tables that have no primary or unique key.
  • Inline editing is not supported for primary key columns. If a table has no primary key, this rule applies to the unique key which is being used for data manipulation.
  • Inline editing is not supported for WordPress media library columns.
  • Inline editing works on existing rows only. It cannot be used to add new rows to a table.
Share This Article :
  • Facebook
  • Twitter
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on 2023-01-13
Table SettingsDynamic Hyperlinks

Submit a Comment Cancel reply

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

Table of Contents
  • Column Labels
  • Column Types
    • WordPress Media Library integration
      • Attachments
      • Audio
      • Hyperlink
      • Image
      • Image URL
      • Video
      • Multiple and single media columns
      • Column format examples
    • Notes
  • Inline editing
    • Inline editing example
    • Inline editing – text and numeric columns
    • Inline editing – date and time columns
    • Inline editing – checkboxes
    • Inline editing – drop-down lists
    • Inline editing – lookups (Data Projects only)
  • Inline editing limitations

Links

Blogs
Tutorials
Demos

Socials

LinkedIn
Twitter

Get in touch

Premium support
Free support forum
Contact us

Resources

WordPress plugin directory
YouTube tutorials

Passionate Programmers B.V. © 2017 - 2023 All rights reserved
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