Location: WP Data Access > Data Explorer > Manage > Settings
This is a very powerful feature which allows you to add a layer around a table or view. Settings defined for a table or view are available to all other plugin tools (Data Explorer, Data Projects and Data Publisher). The following settings are available:
- Add dynamic hyperlinks (add column values to your hyperlink) (Dynamic hyperlinks)
- Define column labels (Column Labels)
- Define column types (with WordPress media library integration) (Column Types)
- Add CRUD forms to the WordPress dashboard menu (read more…)
For example, if you change the column labels of a specific table, these labels are (mostly automatically) used in the Data Explorer, projects (Data Projects) and publications (Data Publisher). This allows you to manage table and views settings at one central location.
The number of settings can and will be extended in the future. The plugin provides a number of action hooks and filters as well, for programmers who want to add their own settings.
A dynamic hyperlink is generated on the fly. Column variables can be added to a hyperlink and are substituted on generation. Allows to add custom HTML (see icons in example below – click to enlarge).
Column labels defined in the Data Explorer are automatically used throughout the plugin in all list tables and data entry forms (Data Explorer, Data Publisher and Data Projects). Within the Data Publisher and Data Projects tools column labels can be overwritten.
There are two types of column labels:
- Column labels for list tables
- Column labels for data entry forms
If you do not defined column labels, the plugin default settings will be used.
WordPress media library integration
The plugin supports the integrate of the WordPress media library. To use this feature, just select the media type from the dropdown list. The plugin will then handle these columns as media columns throughout the plugin, including list tables, data entry forms, Data Publisher pages and Data Project pages.
A real time example of a publication which uses WordPress media library integration is shown below.
|Brand||Brand Type||Color||Photo||Attachments||Price||Licence Plate||Category||Fuel Type||Mileage||Engine Capacity||No Cylinders||Brand||Brand Type||Color||Photo||Attachments||Price||Licence Plate||Category||Fuel Type||Mileage||Engine Capacity||No Cylinders|
Please use the link below to learn more about multiple and single media columns and the different types of media the plugin supports.
A hyperlink column allows plugin users to add a specific hyperlink to table rows. This different from the previously mentioned dynamic hyperlink columns. A hyperlink column is a table column which is physically stored in the database. A dynamic hyperlink is generated on the fly. A dynamic hyperlink allows to use column values in the hyperlink. A hyperlink column does not support this feature.
A hyperlink is stored in JSON or plain TEXT format. If stored in JSON format, it contains a hyperlink label, url and target. A hyperlink column must be large enough to store the JSON string. In most cases varchar(2000) will be sufficient. If stored in TEXT format, enter the full URL, which can be on the same or a different domain.
When a column is set to hyperlink and is stored in JSON format, the column shows a link icon on the data entry (behind the hyperlink column) and allows to enter a label, url and target (see image below – click to enlarge). When stored as plain TEXT it is represented as a normal text field.
Add CRUD forms to the WordPress dashboard menus
This features allows admin users to add CRUD forms for any database table to their own WordPress dashboard menu, as well as the dashboard menu of non admin users. This is the simplest way to create data entry forms.