Validate by Value List With Exceptions (Value List and calc)

[kodama]

Is there a way to do this?

Thanks!

[mr_vodka]

Can you elaborate?

[kodama]

I should have said validate by a value list OR a calc, because value list AND a calc is there already.

I need to validate by a value list and have some exceptions that are not part of the value list but will let the validation pass.

[comment]

You have to validate by calculation alone. In your calculation, check if the entry is a member of the value list OR is an exception.

[kodama]

Thanks comment.

I don't see a way in a calc to validate if a field's data is part of a value list, could you point me in the right direction?

[comment]

Try:

not IsEmpty (

FilterValues ( ValueListItems ( Get (FileName) ; "yourValueList" ) ; ValidatedField )

)

[kodama]

Thanks Commnet!

Works like a charm, I have the field validating off of 2 value lists!

not IsEmpty ( FilterValues ( ValueListItems ( Get (FileName) ; "ValueList 1" ) ; CAO Number ) ) or not IsEmpty ( FilterValues ( ValueListItems ( Get (FileName) ; "ValueList 2" ) ; CAO Number ) )