Hi, Reichenbach 

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,

if you make hyperlinks directly on the Google Spreadsheet,

Google Sheets ( and Excel) have a different way of rendering hyperlinks;

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.

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).

-

Additionally, you can see our Documentation that explains how connecting our tables to existing Google Spreadsheet works here.

https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-google-spreadsheets/

-

And i just wanted to point out that you can try wpDataTables before purchasing

 on our sandbox Demo sites ( you can find links for the main plugin Demo,  

as well as add-on Demos, in my signature),

and there is a 15-day money-back guarantee period, 

so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

Let me know if you have any additional questions. 

Hi, Reichenbach