Hello,
we can see that you solved this issue, happy to see that.
Thank you for sharing how you managed to add the arrow symbol as the hyperlink text to the URL column, perhaps it might be useful for other users who have the same use-case. ??
We can elaborate a bit more about how passing links from Excel to our tables in the plugin works, just to provide additional explanation.
As you noticed, our plugin can not read the hyperlinks directly from the source sheet/Excel ( in case if any user makes a hyperlink in the data source cell itself).
In that case, we 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. ( In your case, you only have the link in the source cells, so you don’t have that issue, of course)
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, the easiest way is ( as you correctly did), to use our?URL Columns, which also allows us to directly add a “Button text” or symbol in the easiest way .
–
Another method, if we need multiple hyperlinks in same cell,
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 >Visit W3Schools.com!</a>
will be rendered as hyperlink of displayed text in the connected table : ” 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).
But then, if we need to use a symbol or a smiley, we would have to add Custom CSS class directly in the HTML inside the cell, and we would have to add CSS to the table in order to get the symbol as needed,
so the solution you chose with the URL Column is certainly the best/easiest way.
Thanks again. Kind regards.
