Do Not Show Field but Show Error when it Fails Validity Check

[mykrobinson]

I hope i worded that subject right. I have a column called _duplicateCheck and it contains a formula that concatenates a patient's last name, first name, middle name, and birthday. If that value is found in the Patients table, the user is not allowed to submit the form and an error message is displayed.

is it possible to have that field concatenating in the background, not visible in the form, but still display the error message in the form if the conditions are met to fail validation?

[Steve · Accepted solution]

You cannot display a column's validity error without also displaying the column itself.

You could conditionally display a column of type Show to display the error message.