Solved

Column validation in Nintex form for Office 365

  • 5 February 2021
  • 2 replies
  • 3 views

Badge +3

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

icon

Best answer by praios81 5 February 2021, 13:48

View original

2 replies

Userlevel 4
Badge +12

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"))


 




 


 

Badge +3

Many thanks @praios81  Much appreciated. It works perfectly!

Reply