Skip to main content
Nintex Community Menu Bar

SharePoint Form - Rule to disable field when calculated field doesn't contain this or this

  • March 16, 2022
  • 4 replies
  • 56 views

Forum|alt.badge.img+2

Hi all - looking for some help with this please.

 

I'm trying to disable a field if the data in a calculated field (Current users department) doesn't equal one of two options. Can get it working with just either option by itself but not for both.....

 

Thanks for any help 🙂22268i0C33F55C834EA2B1.png

 

22267iF0CFDF825CFEE8AD.png

4 replies

Forum|alt.badge.img+11
  • Scholar
  • March 17, 2022

@Amok7__5  This is what worked for me

 

not(Choice!="Option1"&&Choice!="Option2")

 

 


Forum|alt.badge.img+2
  • Author
  • Rookie
  • March 17, 2022

Thanks Nunezma 🙂

Would you know please how I write the rule so it looks at the calculated field (which shows the current users department) and checks it doesn't contain the text "Business Support" or "Quality & Compliance". If True (ie, the current user is not someone from "Business Support" or "Quality & Compliance") then it disables the field the rule applies against. 

 

 


Forum|alt.badge.img+11
  • Scholar
  • March 17, 2022

@Amok7__5 

 

Maybe try something like this:

 

not(and(currentdpt!="Business Support",currentdpt!="Quality & Compliance"))


Forum|alt.badge.img+2
  • Author
  • Rookie
  • March 20, 2022
Thanks again Ninezma - sadly this didn't work either. Have thought of a work around but really appreciate your help all the same 🙂