Hi All,
I'd like to add a link to an external website on a Confluence page using info from the same page to populate the link. Here's my example:
1. I have a table on a Confluence page with some data.
2. I want to use data for a specific cell in that table to generate a link that looks something like this: example.com/[table data].
Anyone know how to do this?
Thanks in advance for sharing your knowledge.
-Dave
Hi @Dave Lines ,
Our Table Filter and Charts for Confluence app and its Table Transformer macro from the version 6.3.0 provide a wiki markdown feature that covers your case.
Here we have a list of use cases collected from our customers (conditional formatting, changing alignment, adding statuses, etc.) and the last one is your case - how to create clickable links from multiple text pieces from Confluence tables put together.
Please check this abstract: here you'll find an example with step-by-step screenshots.
There we use two tables to create links, but for you case the SQL query will be even more simple:
SELECT T1.'Name', T1.'Phone Number', T1.'City',
FORMATWIKI("[" + CONCAT("https://example.com/", T1.'City') + "]") AS 'Workspace',
FORMATWIKI("[The link|" + CONCAT("https://example.com/", T1.'City') + "]") AS 'Workspace 2'
FROM T1
Hope this helps your case.
Hi @Katerina Kovriga _Stiltsoft_ - thanks for your reply. It looks like your app would do what I need to do, but we just bought one app so we can't buy another one right now.
-DL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.