+ Start a Discussion
Ranu JainRanu Jain 

Email Notification with user defined date

Hi,

 

my requirement is :

send an email notification to Accout Owner on Agreement Object .

There is two fields : 1.contract End date 

                                     2. 'Notification days' -  In whihc user set  how many days before contract end date he wnat notifications.

 

I go for the workflow ,Time dependent workflow ,but found I was not able to do this by workflow .I have to use Trigger. 

am I correct? is there any way to do this by workflow.

Best Answer chosen by Admin (Salesforce Developers) 
Hengky IlawanHengky Ilawan

How about create date formula field = Contract End Date + Notification Days. Then use a time based workflow to fire on the date in the formula field?

 

Regards,

Hengky

All Answers

Hengky IlawanHengky Ilawan

How about create date formula field = Contract End Date + Notification Days. Then use a time based workflow to fire on the date in the formula field?

 

Regards,

Hengky

This was selected as the best answer
Ranu JainRanu Jain

Yes ,you are correct.

Thanks  for replying.

I used the formula : formula field = Contract End Date - Notification Days and time based workflow with 0 days.