Toggle Side Panel
Close search

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

  • Salesforce® Discussions

    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 9 years, 2 months 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.