cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
mindymac03
Nintex Newbie

How to suppress a validation rule for a specific SharePoint group?

Jump to solution

I have validation rules for the date fields on my Nintex form. For example, I have one rule that requires the user to enter a future date. Later on down the road, an administrative user goes in and edits this list item, and the date validation rules do not need to be run (for example, the admin user may be adding notes or updating the item status). The dates the user initially entered will likely be in the past by the time the admin user wants to edit this list item. The admin user can always just go into the list view and edit the list item there, but I'd like to allow them to edit via the Nintex form as well. To do that, the date validation rules need to be skipped.

How can I suppress a validation rule (such as one that looks like this: greaterThanOrEqual({Common:CurrentDate}, {Self})) when the user is in the admin SharePoint group I have set up for this for this site?

Labels: (1)
Reply
5 Replies
fhunth
Nintex Newbie

Re: How to suppress a validation rule for a specific SharePoint group?

Jump to solution

Try adding fn-IsMemberOfGroup('MindyGroup') to the rule

Reply
mindymac03
Nintex Newbie

Re: How to suppress a validation rule for a specific SharePoint group?

Jump to solution

Sure. What is the syntax? (I can find examples of enabling/disabling a field or panel using the properties window, but I am not sure how to wrap this around a validation rule)

If not fn-IsMemberOfGroup('xyz') then

greaterThanOrEqual({Common:CurrentDate}, {Self})

This is what I'm after but unclear on what syntax is acceptable to the rule builder.

0 Kudos
Reply
courtney_shelto
Nintex Newbie

Re: How to suppress a validation rule for a specific SharePoint group?

Jump to solution

So for the rule builder, whenever your condition evaluates to true, the thing will happen. So for you, I would say not(fn-IsMemberOfGroup('Group') && greaterThanOrEqual({Common:CurrentDate}, {Self})

This would mean the control is invalid if the person is not in the group and your thing is true. Otherwise, if your thing is true, but the person is in the group, the control remains valid.

Reply
Automation Master
Automation Master

Re: How to suppress a validation rule for a specific SharePoint group?

Jump to solution



Using runtime functions in the Rule Editor you could write: 

and(not(fn-IsMemberOfGroup("Special Admin")), greaterThanOrEqual({Common:CurrentDate}, {Control:Self}))

which,  if you were viewing the form as a member of the group "Special Admin" and the Date Control was set to a value in the past, would translate to:

and(not(true), (true))

which equals: 

and(false, (true))‍‍‍

which equals: false (because and only equals true if all of the conditions are true). 


*note: I had intended to post this earlier, but it was sitting in a draft unpublished from 4pm EST! Whoops!* 

Reply
mindymac03
Nintex Newbie

Re: How to suppress a validation rule for a specific SharePoint group?

Jump to solution

Thanks everyone for the feedback. Here is what I am using and it works great:

not(fn-IsMemberOfGroup("groupname")) && greaterThanOrEqual(Current Date, {Self})

Reply