Checking that email is unique

When a User is adding a new customer, they add an email address which writes to an email column.
I want to check that email against all other emails in that column already, and they should be unable to proceed if the email they entered matches one that’s already in our data.
How would I go about doing this on the data side? I know how to set it up in the layout but I cannot figure out the data side of it.

You need to use a custom form. Capture the email in a user specific column, then use that in a relation matching with the existing data. If the relation is not empty, don’t allow the user to save the record.


Here’s how to build a custom form.

1 Like