Can any one help me out on this?

We have a custom object as Contract Role and it has ROLE as a picklist field which has values as "SA" ,"EB","OR" ETC.It has a master detail relationship with Contract.

Now i would like to send an email notification to Contract role before 90 days from the contract end date whos role is " SA ".This notification should be sent to the "SA Role".

Any example or suggestions .


  • @Tushar Sharma :Thanks for the response.The workflow is set , but i got stucked in role ..how to send email notification for the Role which is SA.This role is a picklist field at custom object.Any customization should be done ,instead of configuration. – SalesforceCRM AccountCRM Jan 29 '16 at 7:31
  • You just need to define the entry criteria to the Workflow. – developer__c Jan 29 '16 at 8:08

Use Workflow time trigger for this. On creation of record set this trigger to before 90 days of expiry date and it will solve your problem.

WF Time Trigger

| improve this answer | |
  • In enter criteria define where role is SA. – Tushar Sharma Jan 29 '16 at 8:52
  • :I didnt get ur point.Any example very much appreciated. – SalesforceCRM AccountCRM Jan 29 '16 at 10:41
  • set your WF to run on insert and in rule define if role = S,A, Now create a time trigger before 90 days of your date and check. – Tushar Sharma Jan 29 '16 at 11:49

If you will always have one and only one of each role, you can use process builder or flow to set a field on the contract record for each recipient role user or email, then fire standard workflow email alerts to the recipient.

Better would be to use flow to send the email. You can use a collection element to store a list of emails, and can send the email from flow or use an email alert from within the flow.

Since the role info is on child object, there is no way to send via workflow on child when parent is edited.

I suppose you could use process builder to update a date field on the child records, and then use an email alert from the child records. Haven't tried it but should work.

| improve this answer | |
  • :Thanks for your response.I dont have an idea of process builder.If possible can you help me out with an example.Any help very much appreciated. – SalesforceCRM AccountCRM Feb 1 '16 at 6:33
  • Actually just saw that your child object is master detail. So you can use a cross object field update to set the field on the parent. Create an email field for each recipient type on parent. Then use a workflow rule to populate the value when child record is created or edited. – gorav Feb 9 '16 at 16:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.