Popular Search formimportsqlqueryshortcode

Adding hyperlinks

Table of Contents

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.

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.

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.

      9 Comments

        • 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

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