When will be the “yearly” interval in workflow automation triggers available?
I have date of birth as value in our employees table, and I would like to receive email notification 1 day before that day.
Is there any easy way on how to do it without “yearly” interval?
(Right now i have metadata table which is filled everyday by custom script with information if this day somebodies birth date is modulo 1 year… and then if there is new record in metadata table, i am sending birthday notification… but it is really not nice solution)
if (doo.model.birthday.currentlyChanged) {
if (doo.model.birthday.value) {
const now = new Date();
const birthday = new Date(doo.model.birthday.value);
let nextBirthday = new Date(new Date(birthday).setUTCFullYear(now.getUTCFullYear()));
doo.model.nextBirthday.value = <any>(nextBirthday < now ? new Date(nextBirthday.setUTCFullYear(now.getUTCFullYear() + 1)) : nextBirthday);
}
else
doo.model.nextBirthday.value = null;
}