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

Is it possible to have rows added to a table under different conditions?

Joli_kdis1b

Is it possible to have rows added to a table under different conditions? For example, if I have a table with 4 rows, and under some circumstances I want the same table to have 6 rows. Depending on, say the variant I've applied to the page?

I know that I can add a separate table with conditional content but that kinda messes up the formating with a new table header and a space between the two tables. I want it to be seamless and dynamic in the same table depending on the variant I export.

Accepted answers

Humashankar VJ

Hi @Joli

With the Table Filter and Charts for Confluence app from the Atlassian. Next, create your initial table on the Confluence page. Then, edit the page and add the Table Transformer macro.

To conditionally add rows, write an SQL query within the macro. For example: "SELECT * FROM T WHERE condition = 'value'". Replace "T" with your table name and "condition = 'value'" with your specific condition.

Finally, configure the macro to apply your SQL query to the table. This will dynamically update your table based on the specified conditions.

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards

All comments

Humashankar VJ

Hi @Joli

With the Table Filter and Charts for Confluence app from the Atlassian. Next, create your initial table on the Confluence page. Then, edit the page and add the Table Transformer macro.

To conditionally add rows, write an SQL query within the macro. For example: "SELECT * FROM T WHERE condition = 'value'". Replace "T" with your table name and "condition = 'value'" with your specific condition.

Finally, configure the macro to apply your SQL query to the table. This will dynamically update your table based on the specified conditions.

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards

Joli_kdis1b

This is very good to know, I will look into using it. Thank you!

Stiltsoft support

Hi @Joli ,

The mentioned Table Filter, Charts & Spreadsheets for Confluence app is ours and for the described case seems that the Table Filter macro will suit you better.

As I understand, you are talking about the Scroll app from another vendor where you can choose the page version and see different content depending on it. The Conditional Content macro can really suit your needs but the issue is that for Version 1 you should have Table 1 with 4 rows and for Version 2 you should have Table 2 with 6 rows. It will look good on the page in view mode but while editing you'll need to update both of these tables.

So, you may insert the Table 2 where you have all the rows, wrap it in our Table Filter macro and set filters on the filtration panel: required column names and blank fields for users to type in their values. So, the table will be filtered on the fly in the view mode and each user will see precise data.

If you are not sure how the app works and what use cases are covered by our macros, please book a call with the team - we'll be able to show you everything live.

Joli_kdis1b

Yes, sorry that I forgot to mention I was using the Scroll macro. Is it possible when exporting to, say, a PDF or HTML Export to have the rows dynamically change based on what variant I chose? Or does it only work inside confluence in view mode?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

filter

data-center

table

table-filter

table-filter-and-charts

scroll

confluence-data-center

table-filter-charts-spreadsheets

conditional-content