# Duplicate entries

**URL:** <https://community.glideapps.com/t/duplicate-entries/29152>\
**Category:** Ask for Help\
**Created:** [July 15, 2021, 7:18pm UTC](https://community.glideapps.com/t/duplicate-entries/29152 "2021-07-15T19:18:47Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Daniel\_Canup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_canup/32/32850_2.png) [@Daniel\_Canup](https://community.glideapps.com/u/Daniel_Canup)\
**Post date:** [July 15, 2021, 7:18pm UTC](https://community.glideapps.com/t/duplicate-entries/29152/1 "2021-07-15T19:18:47Z")

</div>

I have a situation that has been reported to me where a user can log in to create an account and onboard themselves using for instance daniel@…However, if that same user comes back later and enters Daniel@…it creates an entirely different user account. Please Help. I am using Glide Tables, but have one actual google sheet for creating PDFs using a script.

---

<div class="post-metadata">

**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\
**Post date:** [July 15, 2021, 7:57pm UTC](https://community.glideapps.com/t/duplicate-entries/29152/2 "2021-07-15T19:57:25Z")

</div>

Hi Daniel,  
In Glide, “daniel” and “Daniel” are different values, so they’ll log in as different users. You should ask your users to always log in with the same email, or sign in with google.

---

<div class="post-metadata">

**Author:** ![Daniel\_Canup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_canup/32/32850_2.png) [@Daniel\_Canup](https://community.glideapps.com/u/Daniel_Canup)\
**Post date:** [July 15, 2021, 10:13pm UTC](https://community.glideapps.com/t/duplicate-entries/29152/3 "2021-07-15T22:13:56Z")

</div>

Right, but is there no way to force lowercase emails as they are not case-sensitive? Because unfortunately people don’t always check to see if caps lock is enabled or not. On iPhones the first letter is caps by default most of the time.

---

<div class="post-metadata">

**Author:** ![Daniel\_Canup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_canup/32/32850_2.png) [@Daniel\_Canup](https://community.glideapps.com/u/Daniel_Canup)\
**Post date:** [July 26, 2021, 3:33pm UTC](https://community.glideapps.com/t/duplicate-entries/29152/4 "2021-07-26T15:33:19Z")

</div>

So this is impossible then?  
@Jeff_Hager

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 27, 2021, 7:04am UTC](https://community.glideapps.com/t/duplicate-entries/29152/5 "2021-07-27T07:04:41Z")

</div>

Probably yes for now. I don’t know of any way we could force that as a user.

I added a mention to this thread so we can mention it whenever Glide has their next live coding session.

[https://community.glideapps.com/t/future-live-coding-small-fix-wiki-livecodingwiki/29395?u=jeff\_hager](https://community.glideapps.com/t/future-live-coding-small-fix-wiki-livecodingwiki/29395)

---

<div class="post-metadata">

**Author:** ![Daniel\_Canup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_canup/32/32850_2.png) [@Daniel\_Canup](https://community.glideapps.com/u/Daniel_Canup)\
**Post date:** [July 31, 2021, 12:21am UTC](https://community.glideapps.com/t/duplicate-entries/29152/6 "2021-07-31T00:21:52Z")

</div>

I imagine something on this page…  
Perhaps a checkbox for “Force lowercase” 🙂

 ![Screen Shot 2021-07-30 at 6.20.11 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/9/e9f4b335a9670203f81ddb420d100af783bb0256.png)

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [July 31, 2021, 4:46am UTC](https://community.glideapps.com/t/duplicate-entries/29152/7 "2021-07-31T04:46:29Z")

</div>

Hello,  
You have some solutions in “experimental code”

> [@Find Duplicate](https://community.glideapps.com/t/find-duplicate/29780):
>
> Here is a simple code to find duplicates. it is possible to use a search with the case sensitivity option. Code : [https://replit.com/@ManuN2/Find-Duplicates?v=1](https://replit.com/@ManuN2/Find-Duplicates?v=1)

> [@Convert case (lowercase, UPPERCASE, Sentence. Case & Proper Case)](https://community.glideapps.com/t/convert-case-lowercase-uppercase-sentence-case-proper-case/29776):
>
> Notion link: Direct Replit link to fork: Notion library with codes constantly updated: At the moment the types supported are lowercase, uppercase, sentencecase & propercase. I do some trimming and lowercasing in the type input so lower case, LOWer case etc. will also work.

> [@Accents](https://community.glideapps.com/t/accents/29727):
>
> Hello, a small code (special French) to remove accents and punctuation in order to facilitate searches. [image] [image]

---

<div class="post-metadata">

**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:** [July 31, 2021, 4:58am UTC](https://community.glideapps.com/t/duplicate-entries/29152/8 "2021-07-31T04:58:40Z")

</div>

hmm, but would any of those actually help in this case?  
To prevent a duplicate User Profile Row from being created, you need to catch it _before_ the row is added. And because User Profile rows are added by Glide as a result of the sign-in process, you can’t do that. ie. converting an email to all lower-case after the row has been added is too late - the horse has already bolted by then 😉

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [July 31, 2021, 5:02am UTC](https://community.glideapps.com/t/duplicate-entries/29152/9 "2021-07-31T05:02:48Z")

</div>

It is not false

Uhmmm, maybe after that you can display an alert message and restart the registration or reassign the new user to the original duplicates.

The jocker always has a solution for his horse. 🤣
