# Preventing Duplicate Record Submission
**URL:** https://community.glideapps.com/t/preventing-duplicate-record-submission/66064
**Category:** Ask for Help
**Created:** [September 12, 2023, 7:18pm UTC](https://community.glideapps.com/t/preventing-duplicate-record-submission/66064 "2023-09-12T19:18:01Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Monj](https://community.glideapps.com/u/Monj)
#### Post date: [September 12, 2023, 7:18pm UTC](https://community.glideapps.com/t/preventing-duplicate-record-submission/66064/1 "2023-09-12T19:18:02Z")
Hello Everyone,
I’m currently seeking guidance on implementing a method to validate a table for duplicate entries based on names or emails. My objective is to trigger an error message and prevent form submission when duplicates are detected, thus ensuring record uniqueness. Your assistance would be greatly appreciated. Thank you!
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [September 12, 2023, 9:41pm UTC](https://community.glideapps.com/t/preventing-duplicate-record-submission/66064/2 "2023-09-12T21:41:56Z")
> [@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…
---
### Author:  [@Monj](https://community.glideapps.com/u/Monj)
#### Post date: [September 13, 2023, 1:40am UTC](https://community.glideapps.com/t/preventing-duplicate-record-submission/66064/3 "2023-09-13T01:40:10Z")
@nathanaelb Thank you. It took me a while but I believe to have it working now.
---
### Author:  [@Monj](https://community.glideapps.com/u/Monj)
#### Post date: [September 13, 2023, 8:51pm UTC](https://community.glideapps.com/t/preventing-duplicate-record-submission/66064/4 "2023-09-13T20:51:11Z")
@nathanaelb. @Darren_Murphy, I go this to work it the exception of matching the Upper and lower cases. So for example, if I enter [bugsbunny@acme.com](mailto:bugsbunny@acme.com) and [bugsbunny@acme.com](mailto:bugsbunny@acme.com) is there in all lower cases, it works. But if I enter [Bugsbunny@acme.com](mailto:Bugsbunny@acme.com) or [BUGSBUNNY@acme.com](mailto:BUGSBUNNY@acme.com) it will not work.
Do you know how I can make this work?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [September 13, 2023, 9:16pm UTC](https://community.glideapps.com/t/preventing-duplicate-record-submission/66064/5 "2023-09-13T21:16:10Z")
There should be a column type to make all text lowercase. Then compare the lowercase versions.
---
### Author:  [@Monj](https://community.glideapps.com/u/Monj)
#### Post date: [September 13, 2023, 9:22pm UTC](https://community.glideapps.com/t/preventing-duplicate-record-submission/66064/6 "2023-09-13T21:22:44Z")
@Jeff_Hager, So I tried that but the problem is that the input text field does not have a way to convert the text while comparing it. So the data in the field are all in lower cases but if the user enter an Upper case “B” it does not convert to lowercase “b”.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [September 13, 2023, 9:37pm UTC](https://community.glideapps.com/t/preventing-duplicate-record-submission/66064/7 "2023-09-13T21:37:49Z")
You are using a custom form, correct? If so, regardless if the user is typing in uppercase or lowercase, you should have a lowercase column that is converting that input to lowercase, and that is the column you should be using for your compares.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [September 20, 2023, 9:37pm UTC](https://community.glideapps.com/t/preventing-duplicate-record-submission/66064/8 "2023-09-20T21:37:50Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.