[SalesForce] $Profile.Name in Formula field not updating the checkbox

We have a Custom Field (Formula) on User object which has a simple formula to set the checkbox True if the user's profile is System Administrator.

But here i have a user with different profile with the Super User checkbox set to true.

I looked at all other users as well where the checkbox is set to true even though they different profiles.

I found this Similar Issue but our default language is English.

Does anyone have any idea on how to get this working or get current user's profile in a formula field if this doesn't work?

Best Answer

$Profile is the global variable for the profile of the user that is currently logged in. It allows you to to customize formulas to the profile of the user looking at the field. See: Salesforce global variable documentation for more information. You see the formula return true on every user record because you are a system administrator, and therefore your profile name is used for the comparison.

What you would want is the profile name of the user record. This would be Profile.Name (without the dollar sign).

Related Solutions

[SalesForce] Profile picture in formula field

You have to use a Visualforce page to display the pic. Here is an example showing the profile pic on an employee record (custom object).

<apex:page standardController="Employee__c">
    <br />
    <apex:image value="{!Employee__c.user__r.FullPhotoUrl}"/> 
</apex:page>

[SalesForce] Need help IF ISPICKVAL Formula field

I believe you're actually looking for CASE, which allows you to map one value to another. Your formula should probably look like this:

IF(Cognos_BI_Access_Required__c,
    CASE(TEXT(Project__c), 
        "ITS", "ITS Developers/ITS report testers",
        "Tax Dashboard", "Corporate Tax",
        "VEASI", "CR_VEASI_USERS",
        NULL),
    NULL
)

Best Answer

Related Solutions

[SalesForce] Profile picture in formula field

[SalesForce] Need help IF ISPICKVAL Formula field

Related Topic