You need to sign in to do that
Don't have an account?
sfdc@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
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
You could try changing the values to lower case:
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
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:
Let me know if that helps! Please select as best answer if it does. Thank you!
Forgot to remove an extra comma in my last reply, sorry for the typo. Please try this one: