+ Start a Discussion
FIROZ RAYAPATI 9FIROZ RAYAPATI 9 

WHEN EVER I AM CREATING NEW RECORD IN THE CONTACT OBJECT ANY ONE OF THE CONTACT NUMBER(PHONE/MOBILE/HOME PHONE/OTHER PHONE)MANDATORY

Best Answer chosen by FIROZ RAYAPATI 9
Khan AnasKhan Anas (Salesforce Developers) 
I’m glad I was able to help!

Kindly mark this as solved if it's resolved so that it gets removed from the unanswered queue which results in helping others who are encountering a similar issue. *(After you choose the best answer the question is marked as “resolved”)*

Regards,
Khan Anas

All Answers

Sainath VenkatSainath Venkat
@FIROZ RAYAPATI 9,

try below thing in validation rule.
 
OR(ISBLANK(Phoone),ISBLANK(Mobile),ISBLANK(HOMEPHONE),ISBLANK(OTHERPHONE))
make sure to replace phone,mobile,homephone,otherphone with field names that were there in your org.

Mark it bes, if it solves your problem.
 
Khan AnasKhan Anas (Salesforce Developers) 
Hi Firoz,

Greetings to you!

Please try the below validation rule, I have tested in my org and it is working fine. Kindly modify the rule as per your requirement.
If you only want it to be enforced upon creation of record:
AND(
   ISNEW(),
   OR(
      ISBLANK(Phone),
      ISBLANK(MobilePhone),
      ISBLANK(HomePhone),
      ISBLANK(OtherPhone)
   )
)

I hope it helps you.

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. It will help to keep this community clean.

Thanks and Regards,
Khan Anas
FIROZ RAYAPATI 9FIROZ RAYAPATI 9
SORRY FOR BOTH OF YOU BROTHERS I WRITE THE  CODE IN TWO WAYS I AM NOT GET THE RIGHT OUTPUT IT IS ASKING ALL FOUR FIELD VALUES BUT I WANT ONLY ONE FILED IS MANDATORY OUT OF FOUR FIELDS .
 
Khan AnasKhan Anas (Salesforce Developers) 
Oh my bad. Please try below rule:
AND(
      ISNEW(),
      ISBLANK(Phone),
      ISBLANK(MobilePhone),
      ISBLANK(HomePhone),
      ISBLANK(OtherPhone)   
)

Regards,
Khan Anas​​​​​​​
FIROZ RAYAPATI 9FIROZ RAYAPATI 9
YES IT IS WORKING THANK YOU SO MUCH KHAN
Khan AnasKhan Anas (Salesforce Developers) 
I’m glad I was able to help!

Kindly mark this as solved if it's resolved so that it gets removed from the unanswered queue which results in helping others who are encountering a similar issue. *(After you choose the best answer the question is marked as “resolved”)*

Regards,
Khan Anas
This was selected as the best answer
FIROZ RAYAPATI 9FIROZ RAYAPATI 9
SORRY FOR ASKING QUESTION KHAN,
AS OF MY KNOWLEDGE AND FUNCTION IS USED TO CHECK THE ALL CONDITIONS ENTERED IN THE AND FUNCTION , OR FUNCTION IS USED TO CHECK ANY ONE OF THE CONDITION SATISFIED IT WILL RETURN TRUE BUT IN THIS CASE I AM WRITING OR CONDITION IT WILL ASK ALL THE FOUR FIELDS , WHEN EVER I AM USING AND FUNCTION I AM GIVING ONE VALUE IT WILL ACCEPT . HOW THIS CAN WORKING LIKE THIS IF YOU KNOW CAN YOU EXPLAIN ME PLEASE,