Is there a way to prevent users from add duplicate data in to a form? For example, if they are adding a name - “Bob” - but “Bob” already exists in that column then they get a message asking them to enter a different name. I’ve see a couple of threads that touch on this, but did not see a clear solution. Thanks in advance!

I think your dates are in different formats on each sheet, so the templates don’t match. On your event sheet it looks like you are using the ‘short’ date format and on the registration sheet, it’s the ‘medium’ format. For relations to work, each value that’s being compared has to match exactly. If you need to, you can create a math column in one of the sheets to convert the same date from short to medium, or vice versa. You only have to do it in one of them. Then use that math column in the template instead of the date column. When you put a date in a template column, it becomes a string and locks in that format, so it’s no longer a date.

Thank you very much, indeed it is about the difference in format of the dates. I corrected this and everything is OK

Hi @Wiz.Wazeer i need this for my app, this really help. but i checked the link already expired, can i get the new one? thank youu.

@Darren_Murphy Can you share the app that you demonstrated for duplicate entry? I am still not able to figure it out!

It is the perfect solution to this problem!

You can copy the app from the following topic: [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…

That is not a recommended solution since “On submit” actions are not reliable. If the row was not created in time for the delete action to kick in, then the row might still be there and the action fails to do anything. I think the best thing is still to use a custom form.

Can you apply the same on glide pages ? Thanks!

Same concept applies for Pages. Still best to use a custom form for this.

Solution to Prevent Duplicate Entry

Ask for Help

Darren_Murphy April 4, 2022, 1:49pm 57

You can copy the app from the following topic:

Topic		Replies	Views
How do I create a custom form? Community Resources	161	19013	March 24, 2025
Prevent Duplicate Username Ask for Help	7	109	March 6, 2025
Link expired. Can you re-share the link Ask for Help	6	265	April 3, 2024
I want a duplicate check, for example, this name already exists. Ask for Help	4	653	September 13, 2024
Data validation to avoid collision Ask for Help actions	2	321	November 19, 2023

Solution to Prevent Duplicate Entry

Related topics