Table Transformer conditional formatting

Chad Waldron

Confluence Version Number: 7.2.1 (Server)
Build: 8401

 

What I'm after:
A simple table with various columns to input our test results from execution into.

1. When entered a specific value such as 'Bug' it will highlight the entire row red, and 'Test Case' blue, etc. etc..
2. A drop down to have set set values, such as 'Bug' etc. (I understand this is not possible without an add-on based on my research, I'm fine without it).

What I've tried:

1. Excel Table Spreadsheet macro
   I've set everything I need in this macro, but it doesn't seem to update across to different users correctly - and I can't afford to lose any data. It seems flakey and it just doesn't seem to work correctly with cross-users.
2. We have an older version of Confluence on our server so installing add-ons is not a solution for us.

 

So this brings me to the Table Transformer macro.
However, I have zero SQL skills and I've read that FORMATWIKI can do simple conditional formatting but unsure how this works.

Basically, I need help writing an SQL for a table with the following columns (in order):

• Failed Reason
• Build #
• Test Execution Link
• Executed by
• Reviewer
• Comments
• Bugs/Enhancements
• TC Reviewed & Updated?

And then when these values are entered into the 'Failed Reason' column:

1. Bug: the row is changed to red
2. Test Case Error: the row is changed to blue
3. Both: the row is changed to red
4. Passed: the row is changed to green

 

If anybody can help build this It would be much appreciated!

Stiltsoft support

Hi @Chad Waldron ,

As you've mentioned the Table Spreadsheet and Table Transformer macros, we suppose that you have our Table Filter, Charts & Spreadsheets for Confluence app.

If you have any trouble with the Table Spreadsheet macro regarding its behavior, please refer to our support for further investigation. And check the version of the app - the current one is 12.3.1, if yours is an older one, please update.

What concerns the conditional formatting via the Table Transformer macro, you may refer to the example from our documentation and search for similar questions here - there are plenty of them:

• https://community.atlassian.com/t5/Confluence-questions/Conditional-formatting-for-the-row-based-on-a-qualifying-value/qaq-p/2863950
• https://community.atlassian.com/t5/Confluence-questions/Table-transformer-conditional-logic-to-color-code-rows/qaq-p/2605277
• https://community.atlassian.com/t5/Confluence-questions/Format-an-entire-row-using-table-transformer/qaq-p/2853240

As you can see, the structure is the same, we change just column names, values and colors. If you are still stuck, you may refer to our support portal and share your page storage, we'll recreate your page and help you with the query.