Winter 15 - Validation Rule

Question

I have the following validation rule for a Custom Object:

AND(ISPICKVAL( transp__SFT_Trip__r.transp__SFT_Status__c, "Encerrada") , $Profile.Name != "Administrador do sistema")

It only let the admin user change this record when the field of the Trip Object is "Encerrada".

The problem is when another user (which is not the admin) updates the Trip status to "Encerrada" because the system also updates the Custom Object. It was working fine until days ago.

It seems that Salesforce has changed their logic for Validation Rules to get the new value of the field. I want this validation to get the old value of trip status and not the new one.

Answer 1

For validation rules I would use "<>" and not "!="

AND(
ISPICKVAL( transp__SFT_Trip__r.transp__SFT_Status__c, "Encerrada") , 
$Profile.Name <> "Administrador do sistema"
)

Give that a shot!

Answer 2

If I understand it right, when the value in the picklist is Encerrada, only system admins should be able to update that record. You can add one more condition to check if that picklist value was not updated in the current transaction by a non admin.

AND( !ISCHANGED(transp__SFT_Trip__r.transp__SFT_Status__c), ISPICKVAL( transp__SFT_Trip__r.transp__SFT_Status__c, "Encerrada") , $Profile.Name <> "Administrador do sistema" )