How to add multiple hyperlinks for each value within a cell of a table?

[Manu Swami]

Hello,

Wondering if anyone can help me with a query. 

I have created a report by majorly using spreadsheet, Pivot table, Table Transformer macros. My report finally creates a table with some values. In some rare cases, few columns may see multiple values in a cell (because I have grouped by first column) which is completely fine to me. 

The Pivot table output for the rare case is similar to below:

column 1	column 2	column 3
Group By values of column1	1234 6789	forurl1 forurl2

The problem now is, when I wrap the Pivot table output in Table Transformer macro and concatenate a website address prefix with column 3 using formatwiki, I get a single combined link in the output (single hyperlink with the prefix I have provided and the combined values of column3) in the following manner:

FORMATWIKI(" [" + T1.’column3’ + "|https://websitelink” + T1.'column3' + "]\n") AS 'column3',

column 1	column 2	column 3
Group By values of column1	1234 6789	websitelinkforurl1websitelinkforurl2

I understand that the formatwiki is treating all cell values as one and applying the logic but still is there a way I can get two hyperlinks in column 3 cell for both the values like below?

column 1	column 2	column 3
Group By values of column1	1234 6789	websitelinkforurl1 websitelinkforurl2

Note that websitelink prefix is common for both forurl1 and forurl2 values.

Thanks in advance- Manu

[Stiltsoft support]

Hi @Manu Swami ,

For other users who have questions regarding the Table Filter, Charts & Spreadsheets for Confluence app - please refer to our support portal directly. All the questions there are registered, and the portal is confidential - you may share your case freely.

Also the described behavior is an expected one - the cell's contents is treated as a whole entity, so you can't get separate links.

The workaround may be to change order of the steps: firstly, you use the Table Transformer macro to create your links (when your cells are not aggregated, as a result you'll get one link per cell). Then you use the Pivot Table macro on top to group your values. 

[Tomislav Tobijas]

Hi @Manu Swami ,

As I'm guessing you're using Marketplace app (probably this one?) I would probably recommend reaching out to vendors directly. There are some of their support staff here on forums, but they are quite responsive if you use their direct channels (such as the one linked in above).

If you've managed to find a solution in the meantime, others who stumble upon the same/similar issue would probably appreciate it if you could share it here.

Cheers,
Tobi

[Manu Swami]

Thanks, let me reach out to Stiltsoft team. Thank you again for the direct link!

Cheers!