Good morning,
Before buying your plugin I would like to be sure about the following problem:
I have a Google Sheet with hyperlinks. Does wpdatatables automatically export these links to the sheet linking directly to GoogleSheet
Thanks for your Answer.
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:
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
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)
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:
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 :
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
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables