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

Automation - Send Email based on date in a table

Nathan Unsworth

I have a table with a list of contract review dates. I want to setup an automation to review the page every day and send an email to the tagged individual on the row if review date=TODAY. If I were to write the table in Markdown, it would look like this:

|App Name|Next Review Date|App Owner|

|MyApp|3/31/2024|@person|

The date element is used in the Next Review Date field, and the App Owner has been tagged.

How do I setup the automation to key off of that review date?

Accepted answers

All comments

Stefan Salzl

Hi @Nathan Unsworth - welcome to the community,

does this table already exist? Is this a common table within a confluence page?

Best
Stefan

Nathan Unsworth

Yes, it's a table that does exist using the standard Table element in confluence.

Stefan Salzl

Further question:

Are those lines from the table (contracts) coming from jira tickets? Or is this table filled manually?

If filled manually personally I don‘t an easy/straight forward way to iterste over each line and filter out the review date.

Is automation4jira the only possibility or dou you have scriptrunner installed?

With automation i guess it would still need some more (and also kind of scripting) effort.

Didn‘t verify this but what I could imagine is to send a webrequest against the confluence page to get the content and then iterste through each line of the table and compare the date. (unfortunately I don‘t know exactly if and how this can be done)

@Bill Sheboy may I ask if you have any further or even other idea?

Best
Stefan

Nathan Unsworth

I setup an automation to look at the entire page and if there is a task with a due date past due, send an email to the defined group. It works well, just not as focused as I'd like.

Welcome!

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

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

automation