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

Adding hyperlinks

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

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 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…
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-01-13
      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
      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