Checking that email is unique

[MattGlides]

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.

[Darren_Murphy]

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.

[ThinhDinh]

How do I create a custom form?

I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using User Specific Columns and Relations Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particular…

Here’s how to build a custom form.