You need to sign in to do that
Don't have an account?
praveen venkata
Is it possible to send a mail to that user when he dont create new opportunity for 10 days
Email Reminder after 10 days if the Opportunity owner does not create a new opportunity
Can we achieve it either by Workflow or Trigger?
If possible please give me sujestions?
Thanks and Regards,
Praveen.
There are several possible means of accomplishing this. Here is one possible approach:
1. Create a custom field called "Last Opportunity Date" on the user.
2. Create a trigger on Opportunity that updates this field.
3. Create a workflow rule with a time-based action that triggers on Last_Opp_Date__c is not null, with a time action of 10 days after Last_Opp_Date__c that sends the email.
Workflow Rule Name: notifyUserNoOppsRecently
Criteria: Last Opp Date not equal to <no value>
Time Action: 10 Days after Last Opp Date - Send Email
Because it is possible to write flow rule over user object so what we can do is:
1. We will create a field on Opportunity "LastOpptyCreatedDate" ( date time type).
2. Write a trigger on Opportunity which will update User's one field "LastOpptyCreatedDate" on record creation.
3. Now we will write time based Workflow for each 10 days ( with evalutng criteria Today() - LastOpptyCreatedDate= 10)