I am trying to create some business logic that resets a cloned Opportunity check-box field to FALSE if that Opportunity record is cloned (our sales team will clone opportunities with the same accounts for new upsell opps.
Here is what I have tried
Example_Checkbox_field1__c = FALSE,
Example_Checkbox_field1__c = TRUE)
However, using ISCLONE in any IF() statements returns this syntax error:
Function ISCLONE may not be used in this type of formula
Edit: Even though Google and Salesforce Documentation did not help, I figured out that this rule is only acceptable if the Eval Criteria is set to "Created, and every time it's edited.'
Edit NOTE: This rule will not work if Eval Criteria is "Created, and any time it's edited to subsequently meet criteria," OR (more importantly) the first choice of "Created"
Is there a way to create a formula that sets the 'Example_Checkbox_field1__c' field to FALSE right after 'Clone' button was clicked and BEFORE the record is saved?