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

Creating a 'next review' date to turn into a RAG status

Stacey Ropiha

Hi there, I have created a page in Confluence, added a 'Page Properties Report macro' and inserted a /date option to create a future date for review.

This table is then reported onto a parent 'report' page that lists all my pages with their dates, owners, titles, status, last review etc.

I wish for the 'new review' date to flag up red if the date passes. This would allow me to see on the parent report page, quickly, at a glance the passed dates where no review took place. Is this possible?

Please note: I already have a 'status' row but this is manual input, so I do not think this is the answer.

I am not a programmer so would not understand any code. If my idea is not possible, would Jira have to be the option? (which I do use, therefore, would be able to add this in, but am hoping Confluence has an alternative simple answer too).

Thank you

Accepted answers

Stefan Kleineikenscheidt _K15t_

Hi Stacy,

As a workaround without coding: you could enter a task with add a date, like this:

If the date is in the past, if will be displayed in red.

Hope that helps,
-Stefan

Katerina Kovriga {Stiltsoft}

Hi @Stacey Ropiha ,

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

You'll be able to wrap your Page Properties Report into our Table Toolbox macro and create a sequence Page Properties Report <- Table Transformer <- Table Filter.

With the help of the Table Transformer macro you'll be able to set statuses using conditions (compare your dates with "today", for example).

And with the help of the Table Filter macro you'll be able to filter your new statuses and show dates that overpassed "today" or are due soon.

Maybe this also can help.

All comments

Stefan Kleineikenscheidt _K15t_

Hi Stacy,

As a workaround without coding: you could enter a task with add a date, like this:

If the date is in the past, if will be displayed in red.

Hope that helps,
-Stefan

Stacey Ropiha

Stefan, thank you soooo much, that works!! So simple appreciate your reply, again thank you

Katerina Kovriga {Stiltsoft}

Hi @Stacey Ropiha ,

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

You'll be able to wrap your Page Properties Report into our Table Toolbox macro and create a sequence Page Properties Report <- Table Transformer <- Table Filter.

With the help of the Table Transformer macro you'll be able to set statuses using conditions (compare your dates with "today", for example).

And with the help of the Table Filter macro you'll be able to filter your new statuses and show dates that overpassed "today" or are due soon.

Maybe this also can help.

Stacey Ropiha

Good morning Katerina, thank you for responding to my question and I will definitely like to take a look at your answer, it sounds like it would be a good option.

Thank you and have a good day, regards Stacey.

Stefan Kleineikenscheidt _K15t_

You're welcome, @Stacey Ropiha.

While we're at it: If you are getting into Page Properties, make sure you also have a look at our app Orderly Databases, which is Page Properties on steroids: https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Announcing-Orderly-Replace-Confluence-Page-Properties-with/ba-p/1915196

...or watch the new video: https://www.youtube.com/watch?v=0rTJUkPhmWc

That said, it does have date fields, but doesn't support your use case yet. (But will do so soon, and will also be able to send notification emails)

Stacey Ropiha

Excellent, thank you Stefan. I can show this to a few colleagues, it may be of interest to others as well. Thank you!

Welcome!

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

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

confluence

cloud

confluence-cloud