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.

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

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:

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:

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

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'

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

[Katrina Atkinson]

Perfect, i see how it works now!

[Stiltsoft support]

Not sure that I've got you right: try to replace pluses with commas for your query. Commas are used to preserve initial cell formatting.

And, as I see, you have an extra symbol in each function:

1px}", + 'Issues'

You should have 1px}" + 'Issues' or 1px}", 'Issues'.