Activity Forums Salesforce® Discussions How to confirm ISCHANGED Text field users must update blank field Phone number(number field)

  • How to confirm ISCHANGED Text field users must update blank field Phone number(number field)

    Posted by Suraj on April 3, 2017 at 1:38 pm

    I have created a validation rule to ensure that when the users add the contact name they must add the telephone number as well.

    This is my validation rule formula... I am getting a simple syntax error.. of missing ','

    Saurabh replied 7 years ago 2 Members · 1 Reply
  • 1 Reply
  • Saurabh

    Member
    April 3, 2017 at 1:48 pm

    Hi Suraj,

    As much i understand your problem you can create formula like this.

    IF(AND(ISCHANGED(your contact field),ISBLANK(your phone field)),true,false)

    Let me know it will help you or not:

    Thanks:

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos