Hi Dante,

This could be two possible issues :

1. Either it is an 403 ( forbidden) error , which can be caused by bad permission settings on your WP Hosting Server

2. Or, if this is maybe a Google Spreadsheet linked Table, maybe you did not publish the Sheet and set the "Share" option to "Anyone with the link can view".

So, can you please confirm what is this table type, is it maybe linked from a Google Sheet or another table type?

You can certainly double-check with your Hosting Support if there could be a permission issue from their end, here is the full explanation how that works :

The 403 Forbidden Error happens when the web page (or another resource) that you’re trying to open in your web browser is a resource that you’re not allowed to access. It’s called a 403 error because that’s the HTTP status code that the webserver uses to describe that kind of error.

You usually get this error for one of two reasons. The first is that the owners of the webserver have properly set up access permissions and that you’re really not allowed access to the resource. The second reason is that the owners of the webserver have improperly set up permissions and you’re getting denied access when you really shouldn’t be.

You need to contact your hosting provider because you have an issue with your permissions.

Once you do that please let us know if everything is back in order.

Thank you.

Hello,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

When we connect Google Spreadsheets with our tables in the plugin,

our plugin can not read the hyperlinks directly like that from the source sheet.

You would have to change the format of the data in the cells coming from the sheet in order for our plugin to properly render them as links.

Now, it depends if you have one link per cell, or if you have multiple links in the same cell.

1. If you have one link per cell,  perhaps the easiest way is to use our URL Columns.

They have specific rendering rules :

Rendering rules: If the content of the cells contains a combination of “two sticks” – || – everything to the left of this combination is used as an URL address for the link, and everything to the right as displayed text. For example:

https://wpdatatables.com||Check out wpDataTables

will be rendered as: Check out wpDataTables

If the “||” combination is not found in the content, the entire content will be used both for the link and as the display value. For example: https://wpdatatables.com will be rendered as: https://wpdatatables.com

2. Alternatively, you can use String Columns.

They can render custom HTML,  in that case, you would have to wrap the links in the source data as HTML anchor tags, for example :

<a href="https://www.w3schools.com">Visit W3Schools.com!</a>

will be rendered as hyperlink of displayed text : " Visit W3Schools.com! "

 if you use String Columns, you will also be able to have multiple links in the same cell,  and combinations or images with links, etc ( if needed).

Let me know if that makes sense, and if you have any questions. Thanks

Hello,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

Yes, there is a way how you can 'format' your source cells from the Sheet to achieve a 'clickable' image as a link.

You can achieve this with a String Column in our Plugin.

To use an image as a link, just put the HTML <img> tag inside the <a> tag, as on this Tutorial.

If we insert data into a String cell, format the HTML as an image inside a link, something like this:

<a href="your URL Link here"><img src="URL of your Image"></a>

Here is my example, if i have this Liverpool club's logo image, and i want it to redirect the user to the Liverpool Home Page when clicked;

<a href="https://www.liverpoolfc.com/welcome-to-liverpool-fc" target="_blank"><img src="http://localhost/current/wp-content/uploads/2023/10/liverpool-logo-300x209.png" width="100" height="100"></a>

i also add the target blank attribute, so it opens in a new tab, as well as custom width and height as 100 pixels in that String cell.

So, if we hover the mouse over that image, it previews the link undernearth, and if clicked, it redirects to the Liverpool home page in a new Tab.

Let me know if that helps.