# Text entry with check in data base for Prevent Duplicate Entry **URL:** \ **Category:** Ask for Help\ **Created:** [June 18, 2024, 11:05pm UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213 "2024-06-18T23:05:40Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![TeenGlide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teenglide/32/63021_2.png) [@TeenGlide](https://community.glideapps.com/u/TeenGlide)\ **Post date:** [June 18, 2024, 11:05pm UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213/1 "2024-06-18T23:05:40Z")
Hi everyone ! Sorry i’m french so i try my best to explain my problem. I’m trying to create a “text entry” with a sentence underneath that warns the user that the name they just entered in the “text entry” already exists in the column. Thanks for your help ---
**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:** [June 19, 2024, 12:47am UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213/2 "2024-06-19T00:47:08Z")
Is this in a normal form or a custom form, please? ---
**Author:** ![TeenGlide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teenglide/32/63021_2.png) [@TeenGlide](https://community.glideapps.com/u/TeenGlide)\ **Post date:** [June 19, 2024, 1:41am UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213/3 "2024-06-19T01:41:10Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/6/2670ee120abd2c3348da059ad2a8c708e9742d3f.png) I think is the normal form, i put the form with “action” ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [June 19, 2024, 5:31am UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213/4 "2024-06-19T05:31:55Z")
These are the steps you need to do: 1. In the user table add a lookup column (All Name) to pull all names. 2. In your form, add a Hint component that contains a message and visibility settings User Profile \> All Name contains Name. 3. To prevent submitting via buttons you need CSS, follow this link: [Exploring the enhanced capabilities of glides native form](https://community.glideapps.com/t/exploring-the-enhanced-capabilities-of-glides-native-form/69876). ![Screenshot 2024-06-19 at 12.29.30](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/4/243ada3ac6cb6dd405671bdda3273ece5c569c46.jpeg) ---
**Author:** ![TeenGlide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teenglide/32/63021_2.png) [@TeenGlide](https://community.glideapps.com/u/TeenGlide)\ **Post date:** [June 19, 2024, 7:51am UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213/5 "2024-06-19T07:51:44Z")
Man TY very much ! ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/5628db904614e1cbb518160ecd1645dc07d51b88.png) My user can see now the duplicate item ! ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [June 19, 2024, 7:59am UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213/6 "2024-06-19T07:59:53Z")
Have you succeeded in preventing submissions too? ---
**Author:** ![TeenGlide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teenglide/32/63021_2.png) [@TeenGlide](https://community.glideapps.com/u/TeenGlide)\ **Post date:** [June 19, 2024, 9:11pm UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213/7 "2024-06-19T21:11:02Z")
Sorry but i don’t understand what i supose to do with CSS code and table. If you have one process step by step i take it ! TY ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [June 19, 2024, 10:53pm UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213/8 "2024-06-19T22:53:10Z")
You have finished with the table, just one step to add the CSS code so that duplicate names are not submitted intentionally or not. If you follow to the next thread there is a [video](https://youtu.be/mGYUgidT8X4) @Robert_Petitto explaining the steps. ---
**Author:** ![TeenGlide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teenglide/32/63021_2.png) [@TeenGlide](https://community.glideapps.com/u/TeenGlide)\ **Post date:** [June 20, 2024, 12:34am UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213/9 "2024-06-20T00:34:56Z")
Ok so i do the steps : Create hints : ![Capture d’écran 2024-06-20 113015](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/b/2b0ad89fdb8f910858c3cc74a0880a264849e028.png) Name class CSS : ![Capture d’écran 2024-06-20 113101](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4e42c0994f3d65306d890cfa9c035deb27e93695.png) Put CSS code in my option : ![Capture d’écran 2024-06-20 113034](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/8/68fc7b0d58fe40654a066b01775bce74b2fdc318.png) But i can submit , IDK why ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/d/7d7a3fbfae5e528635f620c2fabb7117f7c2c9f9.png) TY for your help ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [June 20, 2024, 12:37am UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213/10 "2024-06-20T00:37:21Z")
You need to change the aria-label code part of the word “Submit” to your language (Soumettre). ---
**Author:** ![TeenGlide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teenglide/32/63021_2.png) [@TeenGlide](https://community.glideapps.com/u/TeenGlide)\ **Post date:** [June 20, 2024, 12:59am UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213/11 "2024-06-20T00:59:26Z")
Ok i change the aria label : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/e/1ef892a9165bddc996a281236dbac4540069c711.png) I still can submit ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [June 20, 2024, 1:06am UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213/12 "2024-06-20T01:06:10Z")
![IMG_2177](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/d/4df4a8bb368d718f874696ace8e376b3683aab1e.jpeg) ---
**Author:** ![TeenGlide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teenglide/32/63021_2.png) [@TeenGlide](https://community.glideapps.com/u/TeenGlide)\ **Post date:** [June 20, 2024, 1:22am UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213/13 "2024-06-20T01:22:07Z")
Ok now i can’t submit ! But my button floating don’t work anymore wtf ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/3/330d69358ca437e2cc40e778e0fd53dee0c805f6.png) TY for your help ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [June 20, 2024, 3:20am UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213/14 "2024-06-20T03:20:16Z")
Try adding !important to the end of the following code: ```auto position: sticky !important; ``` ---
**Author:** ![TeenGlide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teenglide/32/63021_2.png) [@TeenGlide](https://community.glideapps.com/u/TeenGlide)\ **Post date:** [June 20, 2024, 4:07am UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213/15 "2024-06-20T04:07:07Z")
Man your my hero that works ! TY ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [June 27, 2024, 4:07am UTC](https://community.glideapps.com/t/text-entry-with-check-in-data-base-for-prevent-duplicate-entry/74213/16 "2024-06-27T04:07:46Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.