+3
I am trying to make a field required based on the input of two fields.
Design Type: a choice field
Complexity: a choice field
Person: Person
I want Person to be required based on the values chosen from Design Type and Complexity.
Example.
If Design Type = "A" and Complexity = "Medium" or "High" make Person required.
Can anyone tell me the validation syntax I need to enter on the Person validation rule to make this work?
+14
The following should do what you're describing.
(Design Type === "A" && (Complexity === "Medium" || Complexity === "High")) && isNullOrEmpty({Control:Self})To break that down.
1. does Design Type equal "A" ? If it does then...
2. does Complexity equal either "Medium" or "High"? If it does then...
3. does the current person control contain an invalid entry?
This way, if the test fails for Design Type or Complexity, it never checks the validity of the Person Field.
+16
+3
Yes it did, I had forgot to come back and mark correct. Thanks.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.