User ID Validation Rules

Question

Hi all, I want to create a validation rule that only allows certain users the ability to enter data or edit a field, depending on their user ID. Any help would be much appreciated. Thanks Matt

Deepak K Anand · Accepted Answer

Like this:

AND(
    $User.Id <> "ALLOWED USER 1",
    $User.Id <> "ALLOWED USER 2",
    $User.Id <> "ALLOWED USER 3",
    ....,
    $User.Id <> "ALLOWED USER n",
    OR(
        ISCHANGED(Field_1__c),
        ISCHANGED(Field_2__c),
        ISCHANGED(Field_3__c),
        .....,
        ISCHANGED(Field_n__c)
    )
)

Also in order to make this more scaleable I would recommend you to read through this:

http://www.buanconsulting.com/the-custom-setting-every-administrator-needs/

Jake Brushafer · Answer

The best way to do this is to make that field read only at the field level and then open it up to the users you want with a permission set and edit access to that field.  This will prevent them from even editing the field.

User ID Validation Rules

Security

Related Learning

More Help