IF condition in Validation Rules in Salesforce

Поділитися
Вставка
  • Опубліковано 9 лип 2024
  • -How to use IF function in Salesforce Validation rules
    -Hands on IF condition in a validation rule with examples

КОМЕНТАРІ • 11

  • @shaidinmambetov5131
    @shaidinmambetov5131 Рік тому +1

    Thank you for the clarification. That's explained well))

  • @heyimhoben
    @heyimhoben 2 роки тому +1

    New subscriber here, thank you so much

  • @theegalanaveenkumar5751
    @theegalanaveenkumar5751 Рік тому +1

    Nice explanation

  • @LosPane
    @LosPane 2 роки тому +2

    Very useful video!!! Thank you very much! ❤️

  • @heyimhoben
    @heyimhoben 2 роки тому +1

    will u pls continue your channel, upload more pls

  • @ankitkumar2011
    @ankitkumar2011 Рік тому

    Wonderful. Quick important question -- how do we validate correctly the following business logic?
    If status = 'Cancelled'
    then 'Cancellation Reasons' cannot be null
    ALSO
    IF Status = canceled AND Cancellation Reasons ='Others',
    THEN Other 'Cancellation Reasons' != null
    -------------------------------------------------------------------
    I have tried following but doesn't validate :(
    IF(
    AND(
    ISPICKVAL(Status, 'Canceled'),
    NOT(ISPICKVAL(CancellationReasons__c, 'null'),
    AND(ISPICKVAL(Status, "Canceled"),
    ISPICKVAL( CancellationReasons__c ,'Others'),
    Other_Cancellation_Reasons__c= '')
    )
    ),false,true)
    IF(logical_test, value_if_true, value_if_false)

  • @omeryucer5313
    @omeryucer5313 2 роки тому +1

    IF( ISPICKVAL( StageName , "Prospecting") && ISPICKVAL( Type , "New Customer") , ISBLANK( Description ) , false)
    can be used as well instead of nested if? it works i guess

  • @shaidinmambetov5131
    @shaidinmambetov5131 Рік тому

    But why are there two FALSE at the end? The last False refers to the first main IF and the second False refers to?

    • @salesforcesisters425
      @salesforcesisters425  Рік тому

      If you look clearly, there are two IF as well. The inner false is for inner IF and outer False is for outer IF.