How to send notification based on "effective date" which is variable in record producer on ESC opo

[Prathamesh Cha1]

Hi Community,

I have requirement, where notification has to be send based on the "expected date" and task completion state.

where "expected date" is the variable in the record producer and the task name is "effective date task"

For now we can consider that before 2 weeks of "expected date" if the task related that HR case called "effective date task" is not completed then notification has to be send.

[Vijayalakshmi P]

Variables are stored in question_answer table. You may write a script on this table and apply your logic.

[Prathamesh Cha1]

@Vijayalakshmi P yes but how should I send notification and how when to trigger it I am not understanding