How to avoid Calculate field when invisible allows to Submit Survey

[JoseSanchez]

Good morning,

I am using a text field with a  calculate function to check if a record was already entered in the Survey.

If I keep the field "Calculation" visible it returns an error message and does not allow to submit.  If I make it invisible it allows to submit.

What can I do to not allow to submit  when the field Calculation  is not blank and invisible?

Thanks

[DuncanC]

Why you not post the line from the XLSX?  This works as documented. I'm guessing maybe your using relevant when you need to use hidden?

[DougBrowning]

Hidden fields do not trigger a constraint on purpose as it would bring the user to an empty spot on the form and not be possible for them to fix.  This is actually something I asked for as it is confusing to the user.  I think what you have there is the best you can do.  Maybe change the messages and field name to make it look better.