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?
