Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,295,007
Community Members
 
Community Events
165
Community Groups

Auto format values in a wiki table

I'm looking to highlight colors based on values put in a table on a Jira field. I can't copy from excel, because formating doesn't carry over. I'm  wondering if there are any solutions with automation or Structures for Jira addon for server.  The table is updated once and that's it, just looking to see if we can automate the highlights or get them to  carry over if we setup conditional formating in excel. 

The table is standard for all issues and looks similar to below.  Area a would be green for anything between 0 - .05, everything else is red. Area 2 can be between 73.05 and 73.15 is green, everything else is red...and so on. 

 

Areas

value1

Value2

A

2

0.05

B

73.05

73.15

C

 

 

D

 

 

E

 

 

1 answer

1 accepted

0 votes
Answer accepted
Mohamed Adel Community Leader May 02, 2022

Hi @Matthew Patton 

I recommend for your this reading article How to embed Excel tables in Jira issues , it will require some macros & Visual Basic in Excel . but I guess it will help in copy pasting the table with the right format 

 

Regards, 

Mohamed Adel 

Hi Mohamed,

 

The article was good and easy to follow.  Does great formating a table into a wiki format, however it doesn't copy over conditional formating. 

 

Does anyone know if this could be done in groovy/@ScriptRunner ? where I could split the table string by the wiki cell's "|" and parse through the data? Don't need to get into technical details, just wondering plausable. 

Mohamed Adel Community Leader May 07, 2022

in nutshell, Yes you can format the field data in your desired format with ScriptRunner , you can use an update listener to format the field value accordingly. 

 

Regards, 

Mohamed Adel 

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you