• Neeraj Singh 55
  • NEWBIE
  • 15 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 3
    Replies
Hi,

I am trying to write formula criteria to trigger an email from process builder if the fields are miss matched.

I have two fields (picklist) [Entitlement].Cloud_Services_Routing__c & Managed_Service__c(Checkbox).

I would like to trigger an email from process builder when the below criteria is met.

If the value of “Cloud Services Routing” is “Y” and “Managed Service” is not checked
If the value of “Cloud Services Routing” is (“N” or blank/null) and “Managed Service” is checked

Can you please help me to build a formula so that I can use it to trigger the email.

Thanks in Advance!
HI,

  Am trying to restrict phone no to 10 digits and i should accept format either (999) 999-9999 or 999-999-9999 or 999999999.
I wrote below validation 
AND(
    NOT(ISBLANK(Prescriber_Phone_Number_Last_Fill_Date__c)),
    NOT(
        OR(
            ISNUMBER(Prescriber_Phone_Number_Last_Fill_Date__c ),
            REGEX(Prescriber_Phone_Number_Last_Fill_Date__c,"[0-9]{3}-[0-9]{3}-[0-9]{4}"),
            REGEX(Prescriber_Phone_Number_Last_Fill_Date__c, "\\D*?(\\d\\D*?){10}"),
            REGEX(Prescriber_Phone_Number_Last_Fill_Date__c, "[0-9]{10}")
        )
    )
)    

It is allowing more than 10 and Alphabets .

 Can somebody help me how to fix this?
 
How do I change the action bar from the mobile? thanks!
User-added image