Hi all,
Just spent about an hour on a rule that should have taken 30 seconds.
I want to disable a field on my form UNLESS another field = "X" OR "Y"
That's it. The field I'm checking is a list lookup, and I know about parselookup() and I am using that. I even abstracted the parselookup out of formatting rule and have that being done separately in a variable now, still no success.
I've tried about 50 variants, including the following. The best I have gotten is the rule correctly disables if the first match is met (X), but never for the second (Y)
txt_ParsedPersonnelType != "Contractor Affiliate" || "Employee Affiliate"
txt_ParsedPersonnelType != "Contractor Affiliate" || txt_ParsedPersonnelType !="Employee Affiliate"
not(equals(txt_ParsedPersonnelType, or("Contractor Affiliate", "Employee Affiliate")))
not(equals(txt_ParsedPersonnelType, "Contractor Affiliate" || "Employee Affiliate"))
not(equals(txt_ParsedPersonnelType, ("Contractor Affiliate" || "Employee Affiliate")))
not(equals(txt_ParsedPersonnelType, "Contractor Affiliate" || equals(txt_ParsedPersonnelType,"Employee Affiliate")))
Currently, I can get the rule to correctly enable the field if it equals Contractor Affiliate, but it does nothing if i select Employee Affiliate. If i switch the order of these two, the first one is the one that always works.
help!
