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 sol…

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. I…

@ThinhDinh - would you mind expanding on this a little please? My situation: I am using an allowed email list to restrict access to my app. I would like to allow existing users to “invite” new users by adding to the allowed email list, but I want to prevent them from creating duplicate entries. Wha…

Expect a post from me on how to prevent duplicate entries and update entries using actions before the end of this week.

Was there ever a follow up to this? Facing similar circumstance. ▶ Summary

I was hesitating because it involves adding a lot of user-specific columns, and may not be useful for cases with big forms, but I will make a video anyway, when I have time :cry:

I have a working implementation of this. I’ll post a summary later today.

Here is a working solution for preventing duplicate entries as well as giving you the ability to extract the first part of an email to use as user name. I did this on the user profiles sheet as that is where it’s most needed. [sss]

time stamp increment Anyone is welcome to make a copy

Thank you Wiz! I am currently using a form to capture. Would have to switch to details screen correct? ▶ Summary

No…a form you can place on any screen, including inside an inline list. Just create a relation between the form sheet and mNames sheet…and do the LKUPs I carried out on the uP. The form is not our concern…its the sheet to which the form will be writing the info. Once the relation is created you can …

Solution to Prevent Duplicate Entry

Ask for Help

Darren_Murphy December 5, 2020, 4:46am 8

Actually, @Eric_Penn have a look at this thread. What I have is essentially what was discussed there.

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

Solution to Prevent Duplicate Entry

Related topics