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.

Solved the problem by moving “Go back” in the action to any position except the last.

You can’t, but if you look under Settings->Sharing, you might see an option to hide the About screen. I would discourage you from doing anything serious with a copy of a Classic App. Use the technique, sure. But use it in a new App. Classic Apps will go away at some point in the future.

There is no such option on the free plan… Where will the feedback be sent to?

It will be sent to the owner of the Glide account that the App is in.

Daren, If you don’t mind, I made a simplified template based on your app, but on Glide 2 elements. It will be easier for new users to apply it to their tasks, than to use made as Classic app. [image] Unduplicated List

honestly, I’ll never understand the reason for so many columns, it’s enough that the relationship of the custom form, through the name column, is not empty, an alert appears saying that the name already exists and the send button is hidden… I don’t know the reasons existence of boolean and matrix columns.

To add a new record, just check that the link via name is not empty. And when we change existing record and don’t want to change the name (only picture), won’t the name locking be enabled? That’s what matrix columns are for. Of course, can simplify things. If you show us example, we’d appreciate it.

so do you use the same custom form for editing as well? this explains some issues. in my applications I use it only to insert new lines to avoid duplicates.

Forms are different, but the temporary table is common.

Solution to Prevent Duplicate Entry

Ask for Help

ThinhDinh October 22, 2023, 2:44am 87

You can check this thread for a concept.

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