Skip to main content
Nintex Community Menu Bar
Answer

Column validation in Nintex form for Office 365

  • February 5, 2021
  • 2 replies
  • 22 views
K
Forum|alt.badge.img+4

Hi everyone

I would like to have a column in my form (new responsive designer) read-only by default. That's pretty easy to do. But the challenge I have to to make this column not read only any more when another column has a certain value. The other column is a string column, so the options are text values. 

Could someone please assist me on how to achieve this?

I tried something like this but it didn't work: 

 

form.reason = "Sick Leave"

 

The column "On Return" is the one I want as read only by default except when the column "Reason" has the value "Sick Leave"

 

Thanks

Kirk

Best answer by praios81

That should be possible to achieve by using this formula directly in the read only property of your On-Return column:

not(contains([Form].[Reason], "Sick leave"))

 

 

 

    2 replies

    P
    Forum|alt.badge.img+12
    • praios81
    • Answer
    • February 5, 2021

    That should be possible to achieve by using this formula directly in the read only property of your On-Return column:

    not(contains([Form].[Reason], "Sick leave"))

     

     

     

    K
    Forum|alt.badge.img+4
    • kirkie4567
    • Author
    • Rookie
    • February 8, 2021

    Many thanks @praios81  Much appreciated. It works perfectly!

    P
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement