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

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

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) · Accepted solution]

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

[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!