Skip to main content
Nintex Community Menu Bar

Formula to require when yes/no checkbox true and require empty when false

  • May 15, 2020
  • 2 replies
  • 29 views
Forum|alt.badge.img+2

I have a yes/no checkbox that is defaulted to No when new (Occupied). I have a people picker for the user name. I found a formula to require the people picker, which I applied to the Name field if yes which translates to true.  The one below works for that piece. 

and(Occupied==true, isNullorEmpty({self}))

Can I add an OR statement to ensure the people picker is empty if No?

 

    2 replies

    Forum|alt.badge.img+6
    • ethurber
    • Rookie
    • May 15, 2020

    Hi.

     

    I think this what you're looking to do

    (Occupied == true && {self} == "") || (Occupied == false && {self} != "")

    This is a validation rule.  If it evaluates true, it will fail validation.

    Hope this helps.

    Forum|alt.badge.img+2

    Perfect, it worked!! Thanks!

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement