Field validation on user help
Hi,
I created a field validation so only 2 users can change a picklist to a certain value.
I have two other validations already on the field and then for the particular requirement i added
(NOT(([<Type>]=Value) AND ((UserValue('<UserId>')<>'RowID_on_User') OR (UserValue('<UserId>')<>'RowID_on_User')))). So the full thing looks like this:
(NOT(([<Type>]=LookupValue("TODO_TYPE", "Review Call")) AND [<IndexedPick1>] IS NULL)) AND (NOT([<Type>]=LookupValue("TODO_TYPE", "Shipment") AND [<IndexedPick3>] IS NULL)) AND (NOT(([<Type>]=Value) AND ((UserValue('<UserId>')<>'RowID_on_User') OR (UserValue('<UserId>')<>'RowID_on_User'))))
I created a field validation so only 2 users can change a picklist to a certain value.
I have two other validations already on the field and then for the particular requirement i added
(NOT(([<Type>]=Value) AND ((UserValue('<UserId>')<>'RowID_on_User') OR (UserValue('<UserId>')<>'RowID_on_User')))). So the full thing looks like this:
(NOT(([<Type>]=LookupValue("TODO_TYPE", "Review Call")) AND [<IndexedPick1>] IS NULL)) AND (NOT([<Type>]=LookupValue("TODO_TYPE", "Shipment") AND [<IndexedPick3>] IS NULL)) AND (NOT(([<Type>]=Value) AND ((UserValue('<UserId>')<>'RowID_on_User') OR (UserValue('<UserId>')<>'RowID_on_User'))))
0