Need to create a Calendar event eight weeks after a field is populated in Opportunity

Question

We have a requirement to create a calendar entry eight weeks after the Check_Measure_Date__c is populated in the opportunity. I.e if today's date was populated in the field then the users (Production Manager's) calendar would display the opportunity as an Event on the Users Calendar on May 22nd or there abouts - Preferably excluding weekends.

Is this possible using Process Builder. I'm trying to find some documentation from someone who has done this but having no luck. And am getting flow errors when I try it.

Thanks

Thanks SDFCFox,

I'm having an issue where I put the WhatID . Does the below look alright?

Answer 1

Yes, it's mostly possible, but a little tricky because date/time values add using days, so you might need to come up with a precise decimal value to determine the correct time. Also, if multiple records end up with the same date, you'll have overlapping events. I strongly suggest sticking with a Task if you want to use a Date value, or change your field to use a date/time value.

To do this in the Process Builder, you simply need to take the following steps.

First, name your process, and choose to start the process when a record is modified. Next, choose the opportunity object, and do not allow recursion (not necessary). After that, enter the criteria, which should be something like [Opportunity].Check_Measure_Date__c Does not equal Global Constant $GlobalConstant.Null, and make sure you check the "Do you want to execute the actions only when specified changes are made to the record?" box under Advanced.

Finally, create an Immediate Action that sets the Due Date or Start/End Date fields to [Opportunity].Check_Measure_Date__c Formula [Opportunity].Check_Measure_Date__c + 56, which will specify a date eight weeks in the future; remember to set the WhatId field so that it will appear correctly associated to the Opportunity record.

Once activated, it should start creating Task or Event records for you as you desire. If you're getting flow errors, make sure you check your criteria and formulas. Without having an exact error message, it's hard to tell what's wrong, but most of the time it's because of a blank value, so make sure your criteria is correct.