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 to send email 7 days before field date

Fraser Stewart

I am looking to create an automation where is checks all issues within in project and sends an email for each issue to the requestor warning custom field "Contract End" is in 7 days.

So far I have a schedule set to run every day at 8:00

Then: Lookup issues - project = "projectname"

If: {{Contract End}} less than {{now}}(-7d)

Then: Send Email - using smart values in subject and body {{issue.key}} and {{issue.Employee Name_Starter}}

The email is sending and the written text is coming through but the smart values are blank?

Accepted answers

All comments

John Funk

Hi Fraser - Welcome to the Atlassian Community!

The {{issue.key}} should be working with no problems.

For the other field, try: {{issue.Employee Name_Starter.displayName}}

The real question is, are there really any issues that are meeting the query.

So, run the query separately in the search function to be sure there is an issue that should send an email. Then run the rule manually to see what it sends.

Fraser Stewart

I have used the query in the main search function and returns no results. Strange thin though is that when I trigger the automation manually an email is sent just with the smart values missing.

Am I doing something wrong with the query?

Fraser Stewart

I should also have said thank you for the welcome and the assistance

Dick

Hi Fraser,
In the if statement you're not referring to any issue at all. So it compares null to a date.

you should have

if {{lookupIssues.Contract End}} less than {{now}}(-7d)

to include the looked-up issues in your if statement.

More on the power of smart values with lookupIssues on this page

Fraser Stewart

Thank you and I have changed the If to include your changes. I have run the automation and the email has come through but the smart values are still missing?

Dick

if contract end is a custom field, you should lookup its ID first, then use:

if {{lookupIssues.customfield_123456}} less than {{now}}(-7d)

Dick

if you use the search for issues menu command, the customfield (cf_) id is visible when you enter part of the fieldname in the querie space.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

automation

smart-value