How to manage contracts in Jira to be able to get notified by email when there is a renewal coming soon ?
What we have so far :
- New Schema for contracts created in Jira
- Contracts created inside the schema with name, description, type, renewal date and details
- Automation created for email notification
- Smart values created that are linked to the contracts in assets (Name, Type, Renewal Date)
- Email action created to send an email (everyday at 9:00 AM)
(Tried to find a way to configure a "IF" to send the email only when needed)

What is missing or not working for us is :
- The text format of the contracts, in email, (if multiple) is all on one line. Should be separated with date. (ex : ISP Canada | 30 Dec 2024)

- Email are sent everyday no matter if they are contracts that are going to expire or not