Apex Code Development You need to sign in to do that
Don't have an account?
Monishan M To compare text values in process builder formula
Hi,
I have built below formula to check certain condition before updating record via process builder. But not working as expected.
I need to check if the value entered in a text field is exactly matching with my predefined value.
Need to check if response_vod__c is exactly equal to CARD along with certain other conditions
Formula :
AND(CONTAINS([QResponse__c].Test_vod__r.Account_vod__r.Country__c , $Setup.Setting__c.Skr__c ) , NOT(ISBLANK([QResponse__c].Test_vod__r.Survey_vod__r.Product__c)),ISPICKVAL([QResponse__c].Test_vod__r.Survey_vod__r.Status_vod__c , 'Submitted_vod'),[QResponse__c].Response_vod__c = "CARD" )
Can you please help me in redefining this formula.
Thanks
I have built below formula to check certain condition before updating record via process builder. But not working as expected.
I need to check if the value entered in a text field is exactly matching with my predefined value.
Need to check if response_vod__c is exactly equal to CARD along with certain other conditions
Formula :
AND(CONTAINS([QResponse__c].Test_vod__r.Account_vod__r.Country__c , $Setup.Setting__c.Skr__c ) , NOT(ISBLANK([QResponse__c].Test_vod__r.Survey_vod__r.Product__c)),ISPICKVAL([QResponse__c].Test_vod__r.Survey_vod__r.Status_vod__c , 'Submitted_vod'),[QResponse__c].Response_vod__c = "CARD" )
Can you please help me in redefining this formula.
Thanks
Greetings!
I would suggest you to use the Conditions are met radio button since the formula that you have used doesn't have any advanced operators in it.
You can simply select the fields and use the basic operators to check the criteria which will be easy to troubleshoot the issue.
Kindly mark it as best answer if it helps so that it can help others in the future.
Warm Regards,
Shirisha Pathuri