Hi Guys,
I made the below validation rule, a few months ago and at the time it was fine, what it does is it locks my opportunities page when certain stages are selected unless your profile is system administrator, but now i need to change it to allow certain fields to bypass the rule, can anyone suggest to me how this is done please :)
IF(
AND($User.ProfileId <> '00e20000000rJKQ',
OR(
ISPICKVAL(StageName, 'Cost Model Uploaded'),
ISPICKVAL(StageName, 'Client Trading'),
ISPICKVAL(StageName, 'Sign Off Completed'),
ISPICKVAL(StageName, 'Contract Issued to Sales Manager')
)
)
, True, False))
Thanks
James
Hi Steve,
sorry for not being so clear, what needs to be exempt is a variety of fields mainly address fields an example of one is Despatch_Address_Line_1__c this is a Text(32) field, used to input the first line of an address their is many more like this
also this is another example Printer_Required__c this is a picklist field with the values yes and no in it,Other fields types that are included are datefields,
Another thing to note that I never stated before, just only realised is, that this exemption only needs to be effective if the stage is “Client Trading”
If it means creating a separate validation rule this is no problem, also there is probably around 20-50 fields that will need exempting from the rule in the question, I couldn’t include them all,
Any feedback would be great
Thanks
James
