Triple Or for the default value of a Yes/No

  • 6 September 2016
  • 2 replies
  • 2 views
D
Badge +1

I want to use checkboxes on a form, to use later on in rules for panels.

One checkbox gets as default value : fn-IsMemberOfGroup("Company Marketing")

Another one fn-IsMemberOfGroup("Company Engineering") and the last one fn-IsMemberOfGroup("Company Purchasing"). This works.

I also need the inverse : a checkbox that says yes, when a user is not member of any of the three groups above.

How should I do that?

I tried things like

fn-Or(
 fn-Or(  fn-IsMemberOfGroup("Company Engineering"), fn-IsMemberOfGroup("Company Purchasing")), 

fn-IsMemberOfGroup("Company Marketing") )

But it doesn't work.

Or this one:

  fn-If(  fn-Or( fn-IsMemberOfGroup("Company Marketing") ,  fn-IsMemberOfGroup("Company Engineering")) , False ,
 fn-If( fn-IsMemberOfGroup("Company Purchasing") ,
 False ,
 True )
 )

It doesn't work either.

Thanks for any advice.

2 replies

B
Badge +3

I had a similar situation (had a need for a triple OR) and was also unsuccessful.

Instead of OR I used AND and it worked for me.

and(and(and(not(equals(vCurrentUserPreferredName,varReviewee)),not(equals(vCurrentUserPreferredName,varManagerPreferredName))),not(equals(vCurrentUserPreferredName,varDirectorPreferredName))),not(fn-IsMemberOfGroup("nintex")))

Hope this helps... -bill

D
Badge +1

Thanks.

I had tried something similar on a checkbox. There it doesn't work!

When I copied the formula into a Calculated Value, it worked immediately:

and(and( not(isMarketing),not(isEngineering) ), not(isPurchasing))

The isMarketing, isEngineering and isPurchasing values come from checkboxes where I use a formula like:

fn-IsMemberOfGroup("Company Engineering")

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings