I am using code here https://support.google.com/docs/answer/3093313?hl=en to add hyperlinks to my Google Spreadsheet which I import for tables. For some reason the link_label appears in my table but if the link_label is a URL like "Google.com", if I go to COLUMN SETTINGS > DATA > COLUMN TYPE > URL LINK it turns the link_label, in this case "Google.com" becomes an active link but it ignores the "url" I added.
In other words, let's say I use:
HYPERLINK("http://www.google.com/","Google")it shows up in the table as GOOGLE and the link is mysite.tld/google but why? Why is it not google.com as the hyperlink as the code suggests?
Yes because wpdatatables get only visible data from it(which means that link will not be taken)
If you what to use URL column in wpdatatables on proper way you need to insert values that have valid URL links that start with https://example.com or http://example.com. If you insert only string in the column and then change that column type to URL it will be created link with href of the value of that string which is the reason why you get this mysite.tld/google when you click on it
If you what o show URL links as text then you can use two sticks. You can read more about this in our docs on this link.
Also, you can use string column type and then create links with HTML tags for link.
I am using code here https://support.google.com/docs/answer/3093313?hl=en to add hyperlinks to my Google Spreadsheet which I import for tables. For some reason the link_label appears in my table but if the link_label is a URL like "Google.com", if I go to COLUMN SETTINGS > DATA > COLUMN TYPE > URL LINK it turns the link_label, in this case "Google.com" becomes an active link but it ignores the "url" I added.
In other words, let's say I use:
HYPERLINK("http://www.google.com/","Google")it shows up in the table as GOOGLE and the link is mysite.tld/google but why? Why is it not google.com as the hyperlink as the code suggests?
Hi ckad1979,
Thank you for your purchase.
Yes because wpdatatables get only visible data from it(which means that link will not be taken)
If you what to use URL column in wpdatatables on proper way you need to insert values that have valid URL links that start with https://example.com or http://example.com. If you insert only string in the column and then change that column type to URL it will be created link with href of the value of that string which is the reason why you get this mysite.tld/google when you click on it
If you what o show URL links as text then you can use two sticks. You can read more about this in our docs on this link.
Also, you can use string column type and then create links with HTML tags for link.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables