You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
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.
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.
Your query seems okay:
FORMATWIKI(SUM("*Summary*: " + T1.'Summary' + "\n" + "*Additional info*: " + T1.'Additional Info')) AS 'Change Summary'
GROUP BY 'Key'
You may also use the two asterisks instead of one and get an Italic bold.
FORMATWIKI(SUM("**Summary**: " + T1.'Summary' + "\n" + "**Additional info**: " + T1.'Additional Info')) AS 'Change Summary'
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.
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?
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
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'.