# Avoiding Duplicate Entries
**URL:** https://community.glideapps.com/t/avoiding-duplicate-entries/29449
**Category:** Ask for Help
**Created:** [July 22, 2021, 6:22pm UTC](https://community.glideapps.com/t/avoiding-duplicate-entries/29449 "2021-07-22T18:22:21Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Adviuz](https://community.glideapps.com/u/Adviuz)
#### Post date: [July 22, 2021, 6:22pm UTC](https://community.glideapps.com/t/avoiding-duplicate-entries/29449/1 "2021-07-22T18:22:21Z")
We are building a sales app.
Sales Representatives generate their leads and add into the app.
We want to setup a system where representatives can’t add lead if that’s already present into the system.
System should check for following before successful addition of lead.
1. Phone
2. Email
3. Company Name
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 22, 2021, 11:46pm UTC](https://community.glideapps.com/t/avoiding-duplicate-entries/29449/2 "2021-07-22T23:46:41Z")
So a lead wouldn’t be add if there are any of the phone/email/company name that matches something in the database, or it should check for a combination of all 3?
---
### Author:  [@Adviuz](https://community.glideapps.com/u/Adviuz)
#### Post date: [July 23, 2021, 12:01am UTC](https://community.glideapps.com/t/avoiding-duplicate-entries/29449/3 "2021-07-23T00:01:11Z")
Yes, if details match with any of information, system will not add lead and give message to representative that lead is already in database.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 23, 2021, 12:39am UTC](https://community.glideapps.com/t/avoiding-duplicate-entries/29449/4 "2021-07-23T00:39:53Z")
Then I would advise you to create a custom form.
> [@How do I create a custom form?](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014):
>
> 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](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns) and [Relations](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column) Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…
With those 3 fields, you would create 3 relations that match with the existing phone, email and company name columns in your database.
If there are any relations that is not empty, you don’t allow them adding a row to that Sheet.