Confluence Table with dates in front of the columns from today to 30 days ahead

Marcel Kleinlütke_gqxyu0

Hey there,
I am looking for a way to give my users a table showing one day in every line. The line starts with today in lane 1
tomorrow in lane 2 the day after tomorrow in lane 3 and so on and on.... 
and it is supposed to be currently updated automatically every day...

Katerina Kovriga _Stiltsoft_

Hi @Marcel Kleinlütke ,

We can suggest trying our app - Table Filter and Charts for Confluence.

We assume that you have a predefined table with data - with or without column with dates.

If there are dates, then you need to wrap your table into the Table Filter macro. If there are no dates and you want to autofill them, then wrap the table subsequently into the Table Transformer and then into the Table Filter macro.

Let's check the Table Transformer settings:

SELECT FORMATDATE(DATEADD(day, 'Number', "11/05/2021")) AS 'Date',
'Column 1', 'Column 2' FROM
(SELECT ROWNUM() as 'Number', T1.'Column 1', T1.'Column 2' FROM T1)

Here "11/05/2021" is the start date for auto filling.

Here we choose the required date format.

As you can see, now we have auto filled dates pasted day by day.

Now let's move to the Table Filter macro. We need it for filtration - from the start date till "today" (as "today" changes every day, we'll see an additional row every new day).

Here we set the corresponding date format:

And here is your result in the page view mode:

The filtering panel may also be hidden so that your users won't be distracted or to prevent them from changing the filters.

Hope this may help your case.