+ Start a Discussion
Shariq Abbasi.ax705Shariq Abbasi.ax705 

Help with workflow - Using ISCHANGED(OwnerID)

Hello,

I am trying to create a workflow on object "Cases". I have a look up field on Cases called Internal_Originator_c. I want to notify this person whenever the case ownership changes. In the workflow formula, I am writing ISCHANGED(OwnerID) but I am getting the following error.

 

Error: Function ISCHANGED may not be used in this type of formula

 

Why? Can someone sugget a better solution, please? I really appreciate the help.

Best Answer chosen by Admin (Salesforce Developers) 
SteveMo__cSteveMo__c

The ISCHANGED function can only be used in WFR if the trigger type is set to "Every time a record is created or edited".

https://na3.salesforce.com/help/doc/en/customize_functions.htm#ISCHANGEDDef

All Answers

MiguelGuerreiroMiguelGuerreiro

is the Internal_Originator_c a look up on users?

Shariq Abbasi.ax705Shariq Abbasi.ax705

Thanks for your reply. This field is a look up on contacts.

MiguelGuerreiroMiguelGuerreiro
could you post your complete formula code?
Shariq Abbasi.ax705Shariq Abbasi.ax705

That's the only formula I have...ISCHANGED(OwnerID)

I am using the same formula on a different field in another workflow and it's working fine. Not sure what's the problem with this one?

SteveMo__cSteveMo__c

The ISCHANGED function can only be used in WFR if the trigger type is set to "Every time a record is created or edited".

https://na3.salesforce.com/help/doc/en/customize_functions.htm#ISCHANGEDDef

This was selected as the best answer
DipilDipil

Hi,

 

i'm new to salesforce. I want to update a readonly field with a flag or true only if one or more of some selected fields are updated in account. This is applicable for only update operation, and not for new operation.

below is the formula i'm trying to use but i'm getting the same error discussed in this forum. all the "source fields" are text.

 

MSAG_UPDATE=

(formula below)

IF(AND(OR(
 ISCHANGED(MSAGServiceBuilding__c),
 ISCHANGED(MSAGServiceCity__c),
 ISCHANGED(MSAGServiceCommunity__c),
 ISCHANGED(MSAGServiceCountry__c),
 ISCHANGED(MSAGServiceFloor__c),
 ISCHANGED(MSAGServiceHouseNumber__c),
 ISCHANGED(MSAGServiceHousePrefix__c ),
 ISCHANGED(MSAGServiceHouseSuffix__c ),
 ISCHANGED(MSAGServicePostalCode__c ),
 ISCHANGED(MSAGServicePostDirectional__c ),
 ISCHANGED(MSAGServicePreDirectional__c ),
 ISCHANGED(MSAGServiceRoom__c ),
 ISCHANGED(MSAGServiceState__c ),
 ISCHANGED(MSAGServiceStreetName__c ),
 ISCHANGED(MSAGServiceStreetSuffix__c ),
 ISCHANGED(MSAGServiceSuite__c )),(NOT(ISNEW()))),
 TRUE,FALSE
)

 

I would appreciate your help. Thanks.

 

Regards,

Dipil Jain