I'm looking to create a workflow transition validator that scans a "Power Database Custom Field" (which can have multiple values), and if any of the multiple values match, it makes sure that a different User Picker field is properly set.
For instance, the Power Database Custom Field has a list of fruits that can be apple, orange, watermelon, lemon, etc. I also have another User Picker field X that may or may not be blank. If someone chooses "lemon" or "apple" for the fruit, I want to make sure that user field X isn't blank, or potentially that field X is set to a specific person. How can this be accomplished?
Thank you!