Ive asked before and got an answer I could not work with. Im asking again...I cant get this to work and I need actual support. A meeting, a zoom anything!!!
are you using a Table that is linked to Source Data, such as a Google Spreadsheet?
If that is the case,
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.
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
Ive asked before and got an answer I could not work with. Im asking again...I cant get this to work and I need actual support. A meeting, a zoom anything!!!
Hi David,
are you using a Table that is linked to Source Data, such as a Google Spreadsheet?
If that is the case,
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.
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).
-
Let me know if that makes sense, and if you have any questions. Thanks
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