How to send emails based on the data in a table

Radovan Bukoci

I have a Confluence page, on which I have a table of Certificates with 4 columns : Name, Expiry_Date, Reminder_Date, Recipients_List. I want to create a code, which will run once per day on this table. If today = Reminder_Date, it will send email to Recipeints_List, that this certificate is going to expire on Expiry_Date. Please, how it can be done ? / Is there an App on Marketplace to do it  / help with it? Thank you. 

Aron Gombas _Midori_

I suggest a slightly different approach:

• You place each certificate to its own page (which can be beneficial any way)
• Set the expiration date for the page (you can make the date inherited!)
• Set the owners for the page (you can set one or more owners!)

Plus:

• You configure that the "Expired" status is automatically for each page with its expiration date passed
• You configure a notification that emails the pages in the "Expired" status to the owners of the page

Bingo!

It works as you wanted and you can forget it, it will just work.

This workflow can be implemented with the Better Content Archiving app.

(Discl. it is a paid and supported app developed by our team. Free for 10 users!)