+ Start a Discussion
sfdc@isha.ax1814sfdc@isha.ax1814 

Process builder Formula Change-Need Urgent Help

Hi Team,

Iam having a query in Account 'SELECT Id,Name FROM Account WHERE Name LIKE 'Fireeye%'' and this one we converted into process builder formula as 

AND(
NOT(ISBLANK([Case].AccountId )),
NOT(BEGINS([Case].Account.Name, "FireEye"))

another condtion is 
NOT(CONTAINS([Case].Contact.Email, 'FireEye')

But i want to ignore case in my process builder formula as it is validating only 'FireEye' records but i want to validate irrespective of lower/upper/mixed . I want my formula work as Like funtion in Query.


This is urgent change pls help.

Regards,
ISHA
Alaric WimerAlaric Wimer

You could try changing the values to lower case:

/* Example 1. Change to lower case  */
CONTAINS(LOWER([Case].Contact.Email), 'fireeye')

/* Example 2. Change to lower case  */
NOT(BEGINS(LOWER([Case].Account.Name), "fireeye"))
sfdc@isha.ax1814sfdc@isha.ax1814
Hi Thank you somuch for yur quick response.

iam actually trying for one of the field below one but throwing error.
 Please help me to fix this.

ERROR:
The formula expression is invalid: Incorrect number of parameters for function 'CONTAINS()'. Expected 2, received 1


NOT(CONTAINS(LOWER(TEXT([Case].Sub_Category__c), 'remove from field notices')))

Regards,
ISHA
Alaric WimerAlaric Wimer

You're welcome! It looks like the CONTAINS formula needs to have two parameters. In your example, the LOWER formula actually has two parameters. So you just need to move "remove from field notices" from inside the LOWER function to the CONTAINS function. Here's what I mean:

 

NOT(
     CONTAINS(
          LOWER(
               TEXT([Case].Sub_Category__c), 
          ),
          "remove from field notices"
     )
)

 

Let me know if that helps! Please select as best answer if it does. Thank you!

Alaric WimerAlaric Wimer

Forgot to remove an extra comma in my last reply, sorry for the typo. Please try this one:

 

NOT(
     CONTAINS(
          LOWER(
               TEXT([Case].Sub_Category__c) 
          ),
          "remove from field notices"
     )
)
Alaric WimerAlaric Wimer
Please mark "Best Answer" for the response that helped you the most. Thank you!