I'm trying to build a process that will automatically clone the Opportunity A if a "Contract Status" field equals to "Current". The thing is, that "Contract Status" field contains a formula that changes the status depending on the dates (without any manual editing).

As i understand, in Process Builder the process can only be triggered if the record is created or manually edited.

Is there a solution for triggering the process based on the field value changes?

  • Are those dates fields on the same object? If so, then changing the dates would cause an edit of your record, so process builder should work. Feb 22, 2016 at 12:03
  • Hi Robin. Yes, those dates are on the same object, which is Opportunity. Surprisingly enough, it doesn't work though. The settings i have at the moment are the following. Object: Opportunity; Criteria: Opportunity.Contract_Status__c Equals String Current, Opportunity.StageName Equals PickList Closed Won; Immediate Action: Clone. But when the contract start date is reached and Contract Status is automatically changed to "Current", the opportunity is not cloned. When i open that opportunity and manually change any field and save it, only then the opportunity is cloned (manual edit)
    – Echo_2
    Feb 22, 2016 at 13:26
  • + that's the thing, the dates are set long before the process to be triggered. So say today i create an opportunity with a "Contract Start Date" on 01/03/2016. Becuase the date is in future, the "Contract Type" (formula filed) will be "Future". But once that date is reached, "Contract Type" will automatically change to "Current". The question is, whether that automatic formula-based change is considered as "object is edited" or not.
    – Echo_2
    Feb 22, 2016 at 13:36
  • That's not a field change man. A formula is a calculation run at query/view time. The record itself isn't changing, thus why it's never firing. Feb 22, 2016 at 14:54
  • HI cricketlang. Yeah, i kinda figured out that that might be the problem =/
    – Echo_2
    Feb 22, 2016 at 15:09

1 Answer 1


The solution would be for you to create a Process Builder that is scheduled to fire when the date is passed. This would require the least amount of change on your side... simply switch everything you have in your immediate action to the scheduled action and you're set!

  • Hi David. The thing is, I dont have any "Scheduled" box, only the "Immediate Action" box. Is there a way to make it available?
    – Echo_2
    Feb 22, 2016 at 15:10
  • That happens when you don't schedule the action first typically... so create a new set of criteria and actions :/ --- another reason I like to use Flow :), more re-usable than PB. Feb 22, 2016 at 19:01
  • 1
    See this answer to know when scheduled actions are available. Feb 22, 2016 at 20:17
  • 1
    Hi David, Robin. Thank you guys for your answers! Will try to set up Process Builder as advised an see what happens, Checked out the Flow as well - that's the whole new story, maybe will get to it someday ;)
    – Echo_2
    Feb 23, 2016 at 9:32

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .