In this webinar, our experts showcase a variety of demo use cases of how different components of the...
It's a very common request when creating or updating a record with workflow to populate a date field with a calculation. In this blog we will discuss how to do that. Since it is more common to want to set a date out into the future, will use the example of setting an appointment start time to be 3 days after the Account is created.
Let's get started!
1. In the workflow add a step to create an Appointment
2. Now click on Set Properties button. CRM will open a new window with a sample form of an appointment as shown below:
3. Set focus on the Start Time field, since we need to set the date of this field through the workflow. This would change the options on the Form Assistant on the right side
4. In the Day dropdown, select 3
5. In the dropdown below that, select 'After'
6. Click on the Add button. It will show the selected options appear in the text area below
7. Click OK
8. The Start Time field will be polluted with the calculation
9. After filling out any other desired fields on the Appointment, hit Save and Close and publish your workflow
This should set the date as required! We hope this blog was useful to you. Check out our main Dynamics CRM 2015 page for even more tips and tricks!
Happy CRM'ing!
Thanks for the post ...
Bit worried about the pollution in ... "8. The Start Time field will be polluted with the calculation" 🙂
Hi STeve - Thanks for the reply. By pollution do you mean potential instability or ?? I checked in to see if we have encountered any major issues with this approach and checked on two long term clients and so far ok. But the volume was not super high.
Joe, sorry didn't make the smiley big enough ... I presumed you'd meant "will be populated with the calculation"
ah yeah - only now i see the typo 🙂 Good ol auto correct. Thanks!!
Nice, but most people need to add somthing like 3 workdays, excluding weekends (and maybe even Holidays). Is there a way to do that too?
Awesome tutorial. You used an Email in your example, and I know this works for a creation of a new record as well.
In that case; Is there a way to set a date based off of a value from another field?
In my case, I want to set a date field that is another date field plus the value of a numeric field?
Example: End Date Field = Start Date Field + Timespan Field.