Select to view content in your preferred language

How to avoid Calculate field when invisible allows to Submit Survey

208
2
08-09-2024 06:00 AM
JoseSanchez
Frequent Contributor

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

CaptureCalculateField.PNG

 

0 Kudos
2 Replies
DuncanC
Frequent Contributor

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?

0 Kudos
DougBrowning
MVP Esteemed Contributor

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.

0 Kudos