Apex Code Development You need to sign in to do that
Don't have an account?
sandeep kumar 1996 How to write a formula for sending emails on every Friday using workflow
Hi , everyone I'm new to salesforce I have requirement to send emails to the contacts on every Friday using workflows can anyone tell me how to write a formula for it
Create a field of type date on Contact and this field contains the date of coming friday when record is created, use before trigger to populate it
if(createdDate.day == 0) {
// Sunday
comingFridayDate__c = createdDate.addDays(5);
}
if(createdDate.day == 1) {
// Monday
comingFridayDate__c = createdDate.addDays(4);
}
and create a time triggered workflow rule that send a email on this date and 7, 14, 21, 28, 35, 42, 49, 56, 63 days after this date.
You can add max 10 time based workflow rules.
You will have to setup a recurring time-based workflow for this to work. I have explained in my blog post below on how to setup recurring workflows to run everyday. In your case you just have to tweak the workflow so that it runs only every Friday.
https://force-base.com/2016/11/13/power-of-point-click-series-2-learn-how-to-set-up-recurring-time-based-workflows-in-salesforce/
Kindly mark it as an answer if that works !