1

I have created a picklist called status and that picklist has 4 values: New, Pending, Approved and Rejected. I have added a validation rule called statusFieldMustBeNew. So, when a user creates a record then while creating it the status must be new.

If that record is sent for approval then the status will change to pending, approved and rejected (depending upon the condition).

Now my requirement is, when the status field has pending value then I want process builder to post a message to chatter that someone is asking for somekind of approval but processbuilder is respecting that validation rule and I am not able to post a message on Chatter Feed.

so, How do i tell process builder to discard that validation rule? I can attain it by creating a variable and checking the value of it but i want to know if there are other better ways.

The validation rule is:

OR(ISPICKVAL( Status__c, 'Pending'),
ISPICKVAL( Status__c, 'Approved'),
ISPICKVAL( Status__c, 'Rejected'),
ISPICKVAL( Status__c, ''))
Improve this question
5
  • 1
    Please include your validation rule. This site is not a guessing game.
    – Adrian Larson ♦
    Commented Jan 24, 2018 at 3:54
  • I have added validation rule.
    – user51525
    Commented Jan 24, 2018 at 4:29
  • From your validation rule and requirement, I guess that the validation rule fires only when the record is created (New) and the status is among Pending, Approved or Reject.
    – Abhishek Daware
    Commented Jan 24, 2018 at 4:35
  • @Abhishek Daware, yes that is correct.
    – user51525
    Commented Jan 24, 2018 at 4:40
  • If that's the case then @SantanuBoral answer will resolve your issue.
    – Abhishek Daware
    Commented Jan 24, 2018 at 4:45

1 Answer 1

Reset to default
1

As per your validation rule, every time record is edited or updated, rule is satisfying.

If I understand your requirement correctly, you want to fire validation rule during creation and if the status is not New. If that is correct the updated rule will be like this:

ISNEW() && NOT(ISPICKVAL( Status__c, 'New'))
Improve this answer
0

You must log in to answer this question.