You need to sign in to do that
Don't have an account?
sfdc@isha.ax1814
Process builder Formula -Need Urgent Help
Iam having a query in Account 'SELECT Id,Name,outcome FROM Account WHERE Name LIKE 'Unable to Support%'' and this one we converted into process builder formula as
NOT(CONTAINS(LOWER(TEXT([Case].Sub_Category__c), 'remove from field notices')))
Iam facing below error.
ERROR:
The formula expression is invalid: Incorrect number of parameters for function 'CONTAINS()'. Expected 2, received 1
Pls help me to fix this.
Regards,
ISHA
.
NOT(CONTAINS(LOWER(TEXT([Case].Sub_Category__c), 'remove from field notices')))
Iam facing below error.
ERROR:
The formula expression is invalid: Incorrect number of parameters for function 'CONTAINS()'. Expected 2, received 1
Pls help me to fix this.
Regards,
ISHA
.
Greetings!
If you would like to put the criteria same like the SOQL query then you can use the crieria as below:
Name Contains String 'Unable to Support%'' directly in the process builder.
But,not sure why you are trying to query the Case Object.
Even if you are trying to write the criteria on the "[Case].Sub_Category__c" field then also you can simply use the criteria as below:
NOT(CONTAINS([Case].Sub_Category__c, 'remove from field notices'))
The above formula should work.
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future.
Warm Regards,
Shirisha Pathuri
Try below formula: Hope this helps!
Thanks