How can I implement a rule to find a specific page and copy a renamed version of it?

[Tom Borghard]

In our team we have a weekly on a set day and time. In our confluence space we have a page "Weekly" with child-pages for each meeting. The names of these child-pages are the date in "yyyy-mm-dd" format.

Until now I had a rule implemented to create an empty project overview child-page every week that worked just fine.
Now I am trying to implement a rule, that creates a copy of the last meeting overview as a starting point for the next one. 
So let's say we have a meeting every Monday from 10 to 11 am. By rule every Monday at 11:15 am i want to create a copy of that child-page under the same parent page and give it the name of next week's meeting's date. 

E.g. next Monday (2025-01-13) at 11:15 the page 2025-01-20 is automatically created and contains a copy of the page 2025-01-13. So that every team member just needs to update their project status instead of everyone first copying them from last meeting.

I added a rule, the validation works without errors, but no page is created. 

I created it with the date and time as trigger, added a page-branch (checking for pages created by me) and if the condition pagename {{now.jiraDate}} is met, than use "copy page" with the name {{now.plusWeeks(1).jiraDate}}. It does not work.
Branching without any filters did not work either. 
I tried without branching at all before but got an error message, that copying pages by rule does not work without.

I would appreciate if someone knows where my mistake is.

Thanks in advance

[Cyrille Martin]

Hi @Tom Borghard 

So here is what I did to get something close to your expected behavior:

For the the smart value {{date}}, the calculation is {{now.plusDays(5).jiraDate}}

You have to change the CQL filter to get the page created one week ago and not one day ago like in my query [created >= now("-1d")]

The page having all meeting reports is the page id : 757858320

Regards,

[Tom Borghard]

Thank you. I tried this approach with some adjustments for my use case:

1. branch rule ist title ~ {{now.minusDays(6).jiraDate}} AND creator = currentUser()
2. Then: Create variable with smart value {{date}} as now.jiraDate
3. Copy page with name {{date}}.

The rule created the following issure report: Expecting a value for operator '~' after field 'title' but got '2025-01-08'".
But a page with that date as title created by me exists. I tried some other date formats, but that did not fix the issue. Any ideas where my mistake is?

I guess a quick fix would be to add the word "Meeting" to the page title and use the creation date as branch rule. But I would like to figure out if my idea works in confluence as well.

Thanks in advance

[Cyrille Martin]

I'm not sure smart variable can be injected into CQL search.

For sure after the ~ you need to use a ' 

I think you need to look for a page created a week ago, by you and above a specific page. Doing that will allow to simply use the "create >= now("-8d")" to cover the "week ago" without trying to get a title of the page containing a specific date.

The global search will be :

create >= now("-8d") AND parent = xxxxxxxxxx AND creator = currentUser()

Regards,