• Preet Kaur
  • NEWBIE
  • 0 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 8
    Replies
Hi, I'm new to salesforce and would appreciate any help! I've not done very many validation rules either.

If the 'Break Penalty inc. VAT' checkbox is checked and the 'Break Penalty Paid' picklist value is "Yes" an amount must be entered in the 'Break Penalty' field. Allowing the record to save. The formula should also work when the checkbox is checked and an amount is entered in the 'Break Penalty' field, the rule should fire telling the user to state whether the penalty has been paid in the 'Break Penalty Paid' picklist field. ('Yes' or 'No')

The current formula I have is:

AND( ISPICKVAL( Break_Penalty_Paid__c , 'Yes') || Break_Penalty_inc_VAT__c = TRUE && ISBLANK( Break_Penalty__c ) )

I am trying to save the record but I'm getting an error message..below..
User-added image

Any Help is Appreciated!! Thanks
Hi, I'm new to salesforce and would appreciate any help! I've not done very many validation rules either.

If the 'Break Penalty inc. VAT' checkbox is checked and the 'Break Penalty Paid' picklist value is "Yes" an amount must be entered in the 'Break Penalty' field. Allowing the record to save. The formula should also work when the checkbox is checked and an amount is entered in the 'Break Penalty' field, the rule should fire telling the user to state whether the penalty has been paid in the 'Break Penalty Paid' picklist field. ('Yes' or 'No')

The current formula I have is:

AND( ISPICKVAL( Break_Penalty_Paid__c , 'Yes') || Break_Penalty_inc_VAT__c = TRUE && ISBLANK( Break_Penalty__c ) )

I am trying to save the record but I'm getting an error message..below..
User-added image

Any Help is Appreciated!! Thanks

Hello,

 

I am trying to create a validation rule and I have not done very many. Please help.

 

IF Text_Field_A__c is not blank, THEN Picklist_Field_B__c OR Checkbox_Field_C__c can not be blank.

 

I am having trouble figuring out how to encompass the OR statement.

 

Is this even close?

 


And(
 Text_Field_A__c ,
NOT ISNULL (ISPICKVAL(Picklist_Field_B__c, "") ,
OR NOT ISNULL (Checkbox_Field_C__c)
)

 

Thank You!