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

Table filter macro - move entry to second table, when it's marked as "done" or has an "Date"

Ebru A_

Hi together,

We have a protocoll in a table with the columns to dos, creator, description, done etc. When an entry is discussed, we put a "X" or the "Date" in the Column for "Done".

Underneath there is a second table "Archive".

If there is an X or date in the last column, the entry should automatically place itself in the archive table.

How could we do that?

thank you in advance

Accepted answers

Stiltsoft support

Hi @Ebru A_ ,

As your question title mentions the Table Filter macro, I assume you have our Table Filter and Charts for Confluence app installed.

So, for such cases we can suggest trying the following structure:

Wrap the source table in the Table Excerpt macro and then in the Table Filter macro on top
Set the filter inside this Table Filter macro as to show "empty" cells only and hide the filtration panel - now you will see your first table when the page is published
Use the Table Excerpt Include macro to reuse the source table
Wrap this Table Excerpt Include macro into another Table Filter macro and set the reversed filter to show not "empty" cells only and hide the filtration panel - it will be your second table

When some info (date, X, etc.) is entered in the last column of the source table, this row will disappear from the first table and will be shown in the second table.

You may also use extra Table Filter macros to filter these tables (here you may use filtration panel or filters in the headers for other users to use filtration from the page view mode).

All comments

Stiltsoft support

Hi @Ebru A_ ,

As your question title mentions the Table Filter macro, I assume you have our Table Filter and Charts for Confluence app installed.

So, for such cases we can suggest trying the following structure:

Wrap the source table in the Table Excerpt macro and then in the Table Filter macro on top
Set the filter inside this Table Filter macro as to show "empty" cells only and hide the filtration panel - now you will see your first table when the page is published
Use the Table Excerpt Include macro to reuse the source table
Wrap this Table Excerpt Include macro into another Table Filter macro and set the reversed filter to show not "empty" cells only and hide the filtration panel - it will be your second table

When some info (date, X, etc.) is entered in the last column of the source table, this row will disappear from the first table and will be shown in the second table.

You may also use extra Table Filter macros to filter these tables (here you may use filtration panel or filters in the headers for other users to use filtration from the page view mode).

Ebru A_

Hi @Stiltsoft support ,

thank you for your quick answer.

I have created the structure, but it didn't work.

Furthermore, in my opinion this solution works for already existing data in the tables.

In my case, the datas are live. I mean, we are inserting new rows, which is not existing in the second (Archive) table already.

It would be like this:

I am insertig the first row. After some time, the task is done and I edit an X on the last cell.

WHEN the cell is X, then it should be automatically move to the second table.

I don't know how this could work. COnfluence has to copy the row and insert it in the second table. Maybe I have luck and there IS a possibility

Thank you

Ebru A_

2023-07-24 13_31_15-Tabelle - Confluence und 11 weitere Seiten - Profil 1 – Microsoft E.png

Stiltsoft support

Not sure that your structure is correct: your source table (and it will be the one and only manually created table where you update data and add/delete rows) should be wrapped in the Table Excerpt macro (for example, with the name "1" as I see on the screenshot).

But for the second time there should be the Table Excerpt Include macro (not some manually created table and the second Table Excerpt macro as I see on the lower part of the screenshot).

This Table Excerpt Include macro pulls the data from your Table Excerpt macro. You have your source table just "virtually copied".

So, when you go to the page edit mode, you will see your master table, where you update cells, add/delete rows.

When you publish the page, this master table and its virtual copy will be filtered with different filters and you'll get two different table views of completed and uncompleted projects.

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

ms-excel

table