Hi Isabel,
the operators work a bit different.
Instead of [Condition 1]and[Condition 2] they work like and([Condition 1], [Condition 2])
so what should be working is
and(isNullOrEmpty({Self}), or(equals(Request_Type, "Add New Supplier"), equals(Request_Type, "Activate Supplier")))
For usage of other runtime functions this might help too: Runtime functions
Best regards
Enrico
Thanks Enrico, I got this to work.
But now I have a similar issue: A control needs to be hidden if meet 3 conditions. I used this formula but only first two conditions work, the 3rd one has no effect:
Formula Builder
Does OR only work for two not three?
I got this to work by using Not(equals(… ) there is only one value need to match for this control to display, so if value not equal this value then hide.
I have a Nintex form with two fields as follows:
Accessby : drop down field
Approval : people field (hidden by default, shown only based on the value of Accessby)
- I need to hide Approval by default and show Approval field only when Accessby is showing 3 values e.g. "Cat1" "Cat2" "Cat3" (applied hide rule which is working fine)
- When Approval field is shown, I want to make sure users fill in at least one person and not leave as empty field.
I tried the following at the Rule section of the Approval field, but the system does not do Step 2 above, what is the correct formula to ensure that the Approval field is not empty when shown? :
- and(isNullOrEmpty({Self}), or(equals(Accessby, "Cat1"), equals(Accessby, "Cat2"), equals(Accessby, "Cat3")))
- isNullOrEmpty({Self}) and (Accessby == "Cat1" or Accessby == "Cat2"or Accessby == "Cat3")
- isNullOrEmpty({Self}) && (Accessby == "Cat1" || Accessby == "Cat2" || Accessby == "Cat3")
When I tried isNullOrEmpty({Self}) alone, the system immediate prompt me that the Approval field is empty even though the Approval field is hidden (note that I did not tick the "validate when hidden")