# Solution to Prevent Duplicate Entry **URL:** \ **Category:** Ask for Help\ **Created:** [October 22, 2020, 7:32pm UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467 "2020-10-22T19:32:41Z")\ **Posts on this page:** 20\ **Page:** 4
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 20, 2022, 12:36am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/61 "2022-09-20T00:36:29Z")
Same concept applies for Pages. Still best to use a custom form for this. ---
**Author:** ![Gideon\_Nyamekye](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gideon_nyamekye/32/48044_2.png) [@Gideon\_Nyamekye](https://community.glideapps.com/u/Gideon_Nyamekye)\ **Post date:** [September 20, 2022, 7:08am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/62 "2022-09-20T07:08:24Z")
Great, thanks! ---
**Author:** ![serg\_sws](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/serg_sws/32/63017_2.png) [@serg\_sws](https://community.glideapps.com/u/serg_sws)\ **Post date:** [August 17, 2023, 7:24pm UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/63 "2023-08-17T19:24:26Z")
Does anyone have a copy of [https://flying-can-2202.glideapp.io/](https://flying-can-2202.glideapp.io/) saved to copy? Or another example of duplication prevention with creating and deleting a row if it duplicates an existing row. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 18, 2023, 2:32am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/64 "2023-08-18T02:32:16Z")
You can make a copy of my Custom Forms concept App. It shows how to prevent duplicates. It’s a Classic App, but the technique is basically the same. > [@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:** ![serg\_sws](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/serg_sws/32/63017_2.png) [@serg\_sws](https://community.glideapps.com/u/serg_sws)\ **Post date:** [August 18, 2023, 6:20am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/65 "2023-08-18T06:20:24Z")
Thank you. I tried to do as in your application. With additional fields in rows everything is clear. But many design elements are not available to me (either because Glide has changed, or because of the free tariff). I want to apply the simplest solution. Temporarily creating a duplicate string is acceptable to me. ---
**Author:** ![serg\_sws](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/serg_sws/32/63017_2.png) [@serg\_sws](https://community.glideapps.com/u/serg_sws)\ **Post date:** [August 19, 2023, 9:09am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/66 "2023-08-19T09:09:19Z")
Darren, I found a bug in your application. When adding a new animal, the “Go back” action does not work after pressing the Save button. You can press Save button several times and get duplicate records. But in the Cancel button the “Go back” action is executed normally. How to fix it? PS Solved the problem by moving “Go back” in the action to any position except the last. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 19, 2023, 9:20am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/67 "2023-08-19T09:20:55Z")
I don’t have time to test it fully right now, but I just had a quick look and I would guess that the bug is probably with the Delete Row action shown below: ![CleanShot 2023-08-19 at 17.17.14@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/7/b73a1cc2fe6dcde6973286631172ccbbfb46ee58.png) If the relation is empty, then that step will fail and the Go Back won’t be executed. That Delete Row action isn’t actually required. The only reason it is there in the concept App is to prevent the row count from building up. ---
**Author:** ![serg\_sws](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/serg_sws/32/63017_2.png) [@serg\_sws](https://community.glideapps.com/u/serg_sws)\ **Post date:** [August 19, 2023, 9:22am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/68 "2023-08-19T09:22:26Z")
Solved the problem by moving “Go back” in the action to any position except the last. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 19, 2023, 9:33am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/70 "2023-08-19T09:33:38Z")
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. ---
**Author:** ![serg\_sws](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/serg_sws/32/63017_2.png) [@serg\_sws](https://community.glideapps.com/u/serg_sws)\ **Post date:** [August 19, 2023, 9:49am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/71 "2023-08-19T09:49:01Z")
There is no such option on the free plan… Where will the feedback be sent to? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 19, 2023, 9:53am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/72 "2023-08-19T09:53:29Z")
It will be sent to the owner of the Glide account that the App is in. ---
**Author:** ![serg\_sws](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/serg_sws/32/63017_2.png) [@serg\_sws](https://community.glideapps.com/u/serg_sws)\ **Post date:** [August 19, 2023, 9:57am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/73 "2023-08-19T09:57:55Z")
Thank you! ---
**Author:** ![serg\_sws](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/serg_sws/32/63017_2.png) [@serg\_sws](https://community.glideapps.com/u/serg_sws)\ **Post date:** [August 20, 2023, 1:38pm UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/74 "2023-08-20T13:38:20Z")
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. > **[Unduplicated List](https://go.glideapps.com/template/C1eyazdbDw0KxohrWt7z-template-published?privateTemplateToken=QB5WXSWxgOMgvL9wvzre)** ---
**Author:** ![Hobe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hobe/32/55866_2.png) [@Hobe](https://community.glideapps.com/u/Hobe)\ **Post date:** [August 20, 2023, 11:00pm UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/75 "2023-08-20T23:00:23Z")
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. ---
**Author:** ![serg\_sws](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/serg_sws/32/63017_2.png) [@serg\_sws](https://community.glideapps.com/u/serg_sws)\ **Post date:** [August 21, 2023, 9:10am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/76 "2023-08-21T09:10:15Z")
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. ---
**Author:** ![Hobe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hobe/32/55866_2.png) [@Hobe](https://community.glideapps.com/u/Hobe)\ **Post date:** [August 21, 2023, 9:36am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/77 "2023-08-21T09:36:22Z")
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. ---
**Author:** ![serg\_sws](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/serg_sws/32/63017_2.png) [@serg\_sws](https://community.glideapps.com/u/serg_sws)\ **Post date:** [August 21, 2023, 11:23am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/78 "2023-08-21T11:23:48Z")
Forms are different, but the temporary table is common. ---
**Author:** ![chanakarn7547](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chanakarn7547/32/63293_2.png) [@chanakarn7547](https://community.glideapps.com/u/chanakarn7547)\ **Post date:** [August 25, 2023, 1:55am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/79 "2023-08-25T01:55:58Z")
want like this enough to teach or not ---
**Author:** ![chanakarn7547](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chanakarn7547/32/63293_2.png) [@chanakarn7547](https://community.glideapps.com/u/chanakarn7547)\ **Post date:** [August 25, 2023, 1:56am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/80 "2023-08-25T01:56:44Z")
want like this enough to teach or not please ---
**Author:** ![serg\_sws](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/serg_sws/32/63017_2.png) [@serg\_sws](https://community.glideapps.com/u/serg_sws)\ **Post date:** [August 25, 2023, 11:01am UTC](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467/81 "2023-08-25T11:01:15Z")
I don’t understand your message. Write a more detailed sentence. [Previous page](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467.md?page=3) [Next page](https://community.glideapps.com/t/solution-to-prevent-duplicate-entry/17467.md?page=5)