You need to sign in to do that
Don't have an account?
Leonard Silon 16
how do I get contact phone number on a case
On a task I have a custom field named Test that is a checkbox and a formula.
The formula I want is
IF( Related_Case__r.Contact.Phone = Phone_Number_in_Subject__c , TRUE, FALSE)
If the related to is a case (ID starts with 500) and the case has a contact on it, then I want to check if the contact phone and the phone number of the customer that called in are the same. If so, then check the box.
The phone number from subject is 10 digits with no () or dashes. The phone number on the contact has () and dashes.
How do I get the contacts phone on the task
The formula I want is
IF( Related_Case__r.Contact.Phone = Phone_Number_in_Subject__c , TRUE, FALSE)
If the related to is a case (ID starts with 500) and the case has a contact on it, then I want to check if the contact phone and the phone number of the customer that called in are the same. If so, then check the box.
The phone number from subject is 10 digits with no () or dashes. The phone number on the contact has () and dashes.
How do I get the contacts phone on the task
There's a solution already posted to the above question on the success community.
Please refer to below link with a similar discussion.
- https://success.salesforce.com/answers?id=9063A000000eQBHQA2
Kindly mark this as solved if it's resolved.Thanks,
Nagendra