I created a new VR , view below.
AND(
ISCHANGED( Firm__c ),
Firm__r.Available_Provider__c = FALSE
)
When I create a new record, this VR does not fire. I want the VR to fire when someone created a new record as well.
Can you all help me on this?
2 answers
ISCHANGED doesn't fire on new records because it hasn't changed from anything. Try something like this instead
AND(
OR(
ISCHANGED( Firm__c ),
ISNEW()
),
Firm__r.Available_Provider__c = FALSE
)
