You need to sign in to do that
Don't have an account?
Gabe Marquez
Validation Rule Only Works for Sys Admins
I wrote a validation rule on the case object, worked fine for sys admins, but for standard users it always evaluated to true:
NOT(ISPICKVAL(Status,'Closed')) &&
IF( AssetId <> NULL, Asset.AccountId <> AccountId, false)
I wrote 2 others, that didn't ever evaluate to true:
NOT(ISPICKVAL(Status,'Closed')) &&
IF( NOT(ISBLANK( AssetId )) ,
Asset.Account.Name = Account.Name,false)
NOT(ISPICKVAL(Status,'Closed')) &&
IF(AssetId <> NULL,
If( AccountId <> NULL,
Asset.Account.Name <> Account.Name,false), false)
What don't any of these work? What should the rule say??
NOT(ISPICKVAL(Status,'Closed')) &&
IF( AssetId <> NULL, Asset.AccountId <> AccountId, false)
I wrote 2 others, that didn't ever evaluate to true:
NOT(ISPICKVAL(Status,'Closed')) &&
IF( NOT(ISBLANK( AssetId )) ,
Asset.Account.Name = Account.Name,false)
NOT(ISPICKVAL(Status,'Closed')) &&
IF(AssetId <> NULL,
If( AccountId <> NULL,
Asset.Account.Name <> Account.Name,false), false)
What don't any of these work? What should the rule say??
as the validation rule fires when the formula is true, you may use And instead of If function,
ex.
AND(
NOT(ISPICKVAL(Status,'Closed')),
AssetId <> NULL,
Asset.AccountId <> AccountId)
AND(
NOT(ISPICKVAL(Status,'Closed')),
NOT(ISBLANK( AssetId )) ,
Asset.Account.Name = Account.Name)
AND
NOT(ISPICKVAL(Status,'Closed')),
AssetId <> NULL,
AccountId <> NULL,
Asset.Account.Name <> Account.Name)
All Answers
as the validation rule fires when the formula is true, you may use And instead of If function,
ex.
AND(
NOT(ISPICKVAL(Status,'Closed')),
AssetId <> NULL,
Asset.AccountId <> AccountId)
AND(
NOT(ISPICKVAL(Status,'Closed')),
NOT(ISBLANK( AssetId )) ,
Asset.Account.Name = Account.Name)
AND
NOT(ISPICKVAL(Status,'Closed')),
AssetId <> NULL,
AccountId <> NULL,
Asset.Account.Name <> Account.Name)
AND(
NOT(ISPICKVAL(Status,'Closed')),
NOT(ISBLANK( AssetId )) ,
Asset.Account.Name <> Account.Name)
Perfect! Thank you.