Skip to main content
I have a field titled Client Status and I want an email notification to trigger when the field is changed or new, but needs to be marked Yes.  My original formula was working fine and that was the following:  

 

(ISNEW() || ISCHANGED( [Contact].Client_Status__c )) && TEXT([Contact].Client_Status__c) == 'Yes'

 

Now I want to add one more component.  I want to add a Role ID to this, so the alert only happens if the above occurs in as well as the Advisor being a specific role.  Here is what I added, however it is not working.  Can someone please help?  

 

(ISNEW() || ISCHANGED( [Contact].Client_Status__c )) && TEXT([Contact].Client_Status__c) == 'Yes' &&  

 

[Contact].Advisor_Lookup__r.UserRoleId == '00E14000001Qrqk' 

 

Thanks, 

 

Mike
2 answers
  1. Feb 9, 2021, 4:37 PM
    you should not be using role id - that is not best practise. you should use role name - $UserRole.Name