Date change makes additional field required
One of our apps is for our CRM. Currently, we have a Date field for "Forecast Close Date". It's required when a new opportunity is input. Currently, that can be changed at any time for any reason by the Sales Teams. However, I would like add a new, required field, for when that date gets pushed to a date further in the future.
i.e., the date in the "Forecast Close Date" is currently set as 2/28/2018. The Sales Rep goes in, and changes that date to 03/05/2018. At this point, I would like both a dropdown and note box to appear (I know how to do that) and become mandatory.
I've tried working with some of the logic and rules, but everything is based on "the date in the field is before or after today +/- ___". That doesn't work. I would just like it to note that the date is now further in the future than a date that is already in the future.
I hope that makes sense. Any assistance is greatly appreciated.
Thanks,
Mike
i.e., the date in the "Forecast Close Date" is currently set as 2/28/2018. The Sales Rep goes in, and changes that date to 03/05/2018. At this point, I would like both a dropdown and note box to appear (I know how to do that) and become mandatory.
I've tried working with some of the logic and rules, but everything is based on "the date in the field is before or after today +/- ___". That doesn't work. I would just like it to note that the date is now further in the future than a date that is already in the future.
I hope that makes sense. Any assistance is greatly appreciated.
Thanks,
Mike
