nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Format (bold) portion of merged text in a table

Laurie Huth

Currently using the ‘Table Transformer’ Macro...

FORMATWIKI(SUM('Summary' + "\n" + 'Additional Info')) AS 'Change Summary',

where the two fields in JIRA that I am pulling from are called Summary and Additional Info and are combined into one cell with header name Change Summary.

Question: Is there a way to just bold the Summary text in that cell when it pulls in - and leave the Additional Info text un-bolded?

I believe it has something to do with asterisks, but I think I am putting them in the wrong place.

Accepted answers

Katerina Kovriga {Stiltsoft}

Hi @Laurie Huth ,

The Table Transformer macro refers to the new combined cell as a whole one, so it operates with all the contents.

I mean if you join the columns, then the two parts Summary and Additional Info can be both bold or not bold (but both, not partly). So, I'm afraid that your case is not possible.

All comments

Katerina Kovriga {Stiltsoft}

Hi @Laurie Huth ,

The Table Transformer macro refers to the new combined cell as a whole one, so it operates with all the contents.

I mean if you join the columns, then the two parts Summary and Additional Info can be both bold or not bold (but both, not partly). So, I'm afraid that your case is not possible.

Laurie Huth

Thanks! You are such a rockstar at responding to these questions so quickly, Katerina! I appreciate it.

Laurie Huth

I did just figure out something else that might work for me (i.e., a workaround):

FORMATWIKI(SUM("*Summary*: " + 'Summary' + "\n" + "*Additional Info*: " + 'Additional Info')

This is the result:

Screenshot 2022-03-23 100506.png

I was able to put asterisks around text to bold it, but I couldn't figure out how to do it for the actual JIRA field.

Katerina Kovriga {Stiltsoft}

Your query seems okay:

Wed 10-1.png

SELECT 'Key',
FORMATWIKI(SUM("*Summary*: " + T1.'Summary' + "\n" + "*Additional info*: " + T1.'Additional Info')) AS 'Change Summary'
FROM T1
GROUP BY 'Key'

Wed 10-2.png

You may also use the two asterisks instead of one and get an Italic bold.

SELECT 'Key',
FORMATWIKI(SUM("**Summary**: " + T1.'Summary' + "\n" + "**Additional info**: " + T1.'Additional Info')) AS 'Change Summary'
FROM T1
GROUP BY 'Key'

Wed 10-3.png

The same goes with the Jira Issues macro - be aware of what exactly you are typing in. I mean type in "T1." and wait for the macro to present an autocomplete menu to choose from (sometimes Jira Issues macro can modify the column names).

The Jira Issues macro should be wrapped in the Table Transformer macro body instead of the manually created table from my example.

Katrina Atkinson

Is there a way to maintain the text style typed in?

I have a Jira table in a table transformer. However one field we pull is a text space, with vary comments/notes. This text has a specific format in our jira, we bold the title and colored code the other.

When I just have the JIRA table in confluence it reflects exactly what was input to jira, with the colored text and bolded. However once it is in the table transformer the text styles are removed.

Is there a way to maintain the text style while in the table transformer?

Stiltsoft support

You may use commas instead of pluses for the FORMATWIKI function to preserve initial cell formatting, please check this example: https://docs.stiltsoft.com/tfac/dc-server/advanced-table-cells-formatting-58426218.html#Advancedtablecellsformatting-Preservinginitialcellformatting

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server