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; } } }

Dynamic Table operation in Page Properties

Tommy Strømme

So, I have a template used for posting Planned work. Its inside the Page Properties and I have a nice dashboard that shows me the results. As you can see I am using the Easy Dropdown macro. Also got the Table filter and Charts for Confluence macro installed.

I would like the table to be more dynamic. So. let's say you choose "N.A." in one of the dropdowns then I would like the field below grey out. Or also I would like to know how I can have dynamic text / dropdowns appear in a cell based on the value of the dropdown. Been trying to use the table transformer, but have not quite succeeded.

Any help greatly appreciated!

/Tommy

Accepted answers

Stiltsoft support

Hi @Tommy Strømme ,

If you need to color the cells (rows) of your Page Properties Report macro based on statuses, you may indeed use the Table Transformer macro and its CASE WHEN and FORMATWIKI functions.

You may check this example from our documentation https://docs.stiltsoft.com/tfac/cloud/advanced-table-cells-formatting-58426218.html#Advancedtablecellsformatting-Conditionalformatting

And similar Community threads: one, two, three.

Not quite get you request about the dropdowns, but if you mean the multi-level dependent dropdown we can suggest trying the Table Spreadsheet macro. Here is an example of a possible workaround.

All comments

Stiltsoft support

Hi @Tommy Strømme ,

If you need to color the cells (rows) of your Page Properties Report macro based on statuses, you may indeed use the Table Transformer macro and its CASE WHEN and FORMATWIKI functions.

You may check this example from our documentation https://docs.stiltsoft.com/tfac/cloud/advanced-table-cells-formatting-58426218.html#Advancedtablecellsformatting-Conditionalformatting

And similar Community threads: one, two, three.

Not quite get you request about the dropdowns, but if you mean the multi-level dependent dropdown we can suggest trying the Table Spreadsheet macro. Here is an example of a possible workaround.

Tommy Strømme

Thank You for you answer! I will have a look at the Table Transformer again.

About the dropdowns I apologize that I was not quite clear. What I mean was that if you are in a table, and then there is an "Easy DropDown" field called Scandinavian Countries, you select "Norway" , then the next field is called "City" and the dropdown is now showing "Oslo, Bergen, Stavanger, Tromso". You change the First one to Sweden and the second changes to "Stockholm, Gothenburgh, Malmo" etc.. So you change which "Easy Dropdown" is shown depending on another dropdown.

Stiltsoft support

Then I've got your idea about the dropdowns correctly: the Easy Dropdown is not our app, so we can't tell if they provide dependent dropdowns.

The Table Spreadsheet macro that I've mentioned above comes with the Table Filter and Charts for Confluence app but it is a fully functional spreadsheet right in Confluence, it is not about native Confluence tables.

What concerns the Table Transformer macro, it treats the Page Properties Report as a regular table, so, you may apply all the use cases described in our documentation to your report.

Tommy Strømme

Thanks, I got as far as this in he Table Transformer:

SELECT T1.*, FORMATWIKI(" {cell}", CASE WHEN T1.`Planned Work` = "N.A." THEN "Not Applicable" ELSE T1.`Planned Work` END, " {cell}") AS `Planned Work` FROM T1;

However, this overwrites the cells with "N.A." with Not Applicable rather then inserting it in the cell directly below which is what I am trying to get it to do. (fighting with GPT3 and 4 on the side here :-))

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

filter

table