INVALID function

Check if a field is invalid (empty if required, or does not obey the validation rules)

The field becomes invalid when the user starts typing in it or tries to submit the form

INVALID( @FieldName )

Returns 1 if the field is not valid, 0 otherwise

Best use case is to show validation error messages, by creating a Description field with the error message and a visibility formula:

INVALID(@FieldToCheck) = 1

So the error message will show when the field has been checked to be invalid

Need Help?
Already checked the help docs? We're quick to answer and friendly
We'll reply very soon at
Send message