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!

[image] How do I create a custom form? FAQ 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 particula…

@nathanaelb Thank you. It took me a while but I believe to have it working now.

@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 and bugsbunny@acme.com is there in all lower cases, it works. But if I enter Bugsbunny@acme.com or BUGSBUNNY@acme.com it will not work. Do you know how I can make this work?

There should be a column type to make all text lowercase. Then compare the lowercase versions.

@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”.

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.

Preventing Duplicate Record Submission

Ask for Help

nathanaelb September 12, 2023, 9:41pm 2

Topic		Replies	Views
Data validation to avoid collision Ask for Help actions	2	321	November 19, 2023
Prevent duplicates from text entry Ask for Help	4	1475	September 20, 2022
Can I make the use of uppercase words mandatory in the forms? Ask for Help	9	287	February 27, 2024
Prevent Duplicate Username Ask for Help	7	109	March 6, 2025
Solution to Prevent Duplicate Entry Ask for Help	85	8807	October 22, 2023

Preventing Duplicate Record Submission

Related topics