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

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
    • Table Settings
    • Column Settings
    • Search Settings
    • Geolocation 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
  • Plugin Variables
    • WordPress user ID in SQL
    • Environment variables
  • 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

Adding hyperlinks

There are two ways to add a hyperlink to a data table:

  1. Add a hyperlink column
  2. Add a dynamic hyperlink

Hyperlink column #

A hyperlink column is a table column which is physically stored in the database. With this type of hyperlink you can add a specific hyperlink to each table row. The plugin generates the necessary features to support hyperlink editing in the data entry form. You can enter a label, url and target. An example could be a link to product specifications on the site of the product supplier.

  • Read more about hyperlink columns…

Inline demo (try column hyperlink) #

NameImageIn StockHyperlinkDescription
NameImageIn StockHyperlinkDescription

Dynamic hyperlink #

A dynamic hyperlink is a computed column generated on the fly. Column variables can be added to a hyperlink and are substituted on generation.

  • Read more about dynamic hyperlinks…
Once a dynamic hyperlink is created, it can be added to a data table. Click on the Select button of your data table in Data Tables to add the hyperlink to your data table. That’s all!

    Inline demo (try column actions) #

      ActionsNameImageIn StockDescription
      ActionsNameImageIn StockDescription

      This example uses the following HTML to create the actions links

      <a href="javascript:alert('Action not implemented for $$product_name$$')" class="dashicons dashicons-plus-alt"></a>
      <a href="javascript:alert('Action not implemented for $$product_name$$')" class="dashicons dashicons-dismiss"></a>
      <a href="javascript:alert('Action not implemented for $$product_name$$')" class="dashicons dashicons-admin-generic"></a>
      

      Notice that variable $$product_name$$ is substituted with the column value of each row.

      Share This Article :
      • Facebook
      • Twitter
      • LinkedIn
      • Pinterest
      Still stuck? How can we help?

      How can we help?

      Updated on 2023-05-30
      SEO friendly data tablesExtension Manager

      9 Comments

      1. Steve Fulton, UE
        Steve Fulton, UE on 2020-10-04 at 8:42 pm

        Hi there

        The link for “More information about hyperlink columns…” on https://wpdataaccess.com/docs/data-tables/hyperlinks/ is broken.

        I am trying to learn about this.
        Thanks
        Steve Fulton, UE

        Reply
        • Peter Schulz
          Peter Schulz on 2020-10-05 at 12:26 pm

          Thank you for reporting Steve! I fixed the broken link . Let me know if you have any questions.

          Thanks,
          Peter

          Reply
      2. Zerzer
        Zerzer on 2020-10-14 at 6:04 pm

        Hi,

        I was wondering if it was possible to change the name of the hyperlink within the popup window, because it has currently “wpda_hyperlink_0” as a label.

        Thank you in advance for your time and answer.

        ZZ

        Reply
        • Peter Schulz
          Peter Schulz on 2020-10-14 at 6:54 pm

          Hi Zerzer,

          That is a bug! While I am typing this message I am uploading version 3.6.5 which contains a fix for this issue. šŸ™‚ You just need to update… šŸ˜‰

          Thanks for reporting,
          Peter

          Reply
      3. Zerzer
        Zerzer on 2020-10-15 at 1:04 am

        Hi Peter,

        Thanks you very much for your work, it is as you say šŸ˜‰

        Have a good day,

        ZZ

        Reply
      4. Igor
        Igor on 2020-10-22 at 12:24 pm

        Hello Peter,

        I am a bit novice in this area and I need a bit of help. I cannot figure out how could I attach a dynamic link to an image. Click on the image would bring me to a page of the product I clicked on it’s image. I have my image column set to Image URL

        I cannot send the link to a site because I am still on localhost.

        Thank you for your answer and have a nice day,

        Igor

        Reply
        • Peter Schulz
          Peter Schulz on 2020-10-22 at 9:08 pm

          Hi Igor,

          You can use a dynamic hyperlink. In your case you need to write a kind of HTML template in the HTML field. This could for example be something like:

          <a href=”<your-product-url>/product-$$product_id$$.php”><img src=”<your-image-url>/product-$$product_id$$.gif”></a>

          The plugin will substitute $$product_id$$ with the value of column product_id for each row and and image with a hyperlink.

          Here is the documentation for dynamic hyperlinks:
          https://wpdataaccess.com/docs/data-explorer-settings/dynamic-hyperlinks/

          Does this help Igor?

          THX Peter

          Reply
          • Igor
            Igor on 2020-10-26 at 6:40 pm

            Hello Peter,

            Thank you for your quick reply- I even couldn’t see it on the same day for I had to dedicate my time to some other work

            I succeded to make a dynamic link for a picture. I made it like that (this is not exactly the end of job but it’s one step)

            Interesting – the dynamic link didn’t do the work when I inserted a link to the picture, like this:

            where in a database I have exactly the same link for example:

            http://localhost/geonext/luxtek/wp-content/uploads/2020/10/0931480660.jpg

            I’m also sending dropbox links for two pictures perhaps they will enlighten if I my words were clumsy.

            https://www.dropbox.com/s/vkica4bihkotk0i/2020102601-WPACCESS-01.1.png?dl=0

            https://www.dropbox.com/s/z84o428flexrbnk/2020102602-WPACCESS-02.png?dl=0

            Now I have to prepare a file to accept the id ($$codigo$$) of product

            Thank you very much for your help!

            Have a nice day,

            Igor

            Reply
            • Peter Schulz
              Peter Schulz on 2020-10-27 at 7:14 am

              Hi Igor,

              You should be able to use a column value for your links and pictures both. The plugin just substitutes the placeholders. What values are stored in column imagem-id-link?

              Thanks,
              Peter

              Reply

      Submit a Comment Cancel reply

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

      Table of Contents
      • Hyperlink column
        • Inline demo (try column hyperlink)
      • Dynamic hyperlink
        • Inline demo (try column actions)

      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

      IMPORTANT message for free users with version 5.3.9 installed

      WP Data AccessĀ versionĀ 5.3.9 is not seeing new updates in the plugin page. The latest version is currently 5.3.15.

      To download the latest update, please follow these steps:

        • Deactivate and delete version 5.3.9. This willĀ NOTĀ delete your data, but if you’re worried, you can also simply deactivate versionĀ 5.3.9, and then rename the plugin folder temporarily via FTP.
        • Download the lastest version of WP Data Access from the WordPress plugin directoryĀ (click theĀ DownloadĀ button)
        • Login to your WordPress dashboard
        • Navigate to PluginsĀ >Ā Add NewĀ >Ā Upload Plugin
        • Select the zip file for 5.3.15, and then clickĀ Install Now.
        • Activate the new version (and delete the old version 5.3.9).

       

      Feel free to message us if you encounter any problems during the update.