Skip to main content
Nintex Community Menu Bar
Solved

Making field required based on Yes/No the other based on number field

  • May 5, 2021
  • 4 replies
  • 647 views
C
Forum|alt.badge.img+8

I have a boolean Yes/No hiding a panel with three controls. One of them is a number column with a default of 0. I'm trying to have that column required if the boolean is Yes and the number column still has a zero in rather than any other number. I have below but it's not working. As always thanks you to everyone for your help.

 

contains(Yes/No Column, "true") && not(Hours, "0")

Best answer by kunalpatel

@ctoper11 try below formula in validation rule:

 

and(greaterThan(Title,"0"), equals(YesNo, True))

    4 replies

    K
    Forum|alt.badge.img+12
    • kunalpatel
    • Rookie
    • Answer
    • May 6, 2021

    @ctoper11 try below formula in validation rule:

     

    and(greaterThan(Title,"0"), equals(YesNo, True))

    C
    N
    Forum|alt.badge.img+11
    • Nunezma
    • Scholar
    • May 6, 2021

    @ctoper11  boolean is Yes and the number column still has a zero:

     

    =Yes/No Column&&Hours=="0"

    C
    C
    Forum|alt.badge.img+8
    • ctoper11
    • Author
    • Rookie
    • May 6, 2021
    @kunalpatel this did work I just replaced greaterThan with lessThanOrEqual
    C
    Forum|alt.badge.img+8
    • ctoper11
    • Author
    • Rookie
    • May 6, 2021
    @Nunezma this looks simpler but it does not seem to be working the Yes/No Column name is actually =A3R3 so my formula looks like below. That look correct?

    =A3R3&&H3=="0"
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement