Skip to main content
Michael Dely 님이 #Collaboration에 질문했습니다
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].Premier_Client__c )) && TEXT([Contact].Premier_Client__c) == 'Yes' &&  

 

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

 

Thanks, 

 

Mike
답변 2개
  1. 2021년 2월 9일 오전 12:10
    For the first formula you used the Client_Status__c field. But for the second one you are using Premier_Client__c field. Is that right? Because you said that you want to add a component in the first formula.

     

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

     

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