# If a CAP in the email, not matching
**URL:** https://community.glideapps.com/t/if-a-cap-in-the-email-not-matching/15868
**Category:** Report a Bug
**Created:** [September 16, 2020, 4:48am UTC](https://community.glideapps.com/t/if-a-cap-in-the-email-not-matching/15868 "2020-09-16T04:48:41Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@McJagger](https://community.glideapps.com/u/McJagger)
#### Post date: [September 16, 2020, 4:48am UTC](https://community.glideapps.com/t/if-a-cap-in-the-email-not-matching/15868/1 "2020-09-16T04:48:42Z")
My app’s URL: cs.backtoset.app
Apologies if addressed before, didn’t see it.
So after a few hours of not figuring out why things weren’t matching, I FINALLY discovered that somehow users who had caps in their emails (manually added in a list) didn’t match the emails right via relation to their emails in users list. After literally going line by line to see what was different I noticed the few with issues had caps in their emails entered by an admin, but not in user list. Once I changed it, the problem was solved. So, that was fun 🙂
Any way to avoid this in the future as it may still be a problem as people add someone’s email in a section then when the relation tries to find them, it can’t
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [September 17, 2020, 2:37am UTC](https://community.glideapps.com/t/if-a-cap-in-the-email-not-matching/15868/2 "2020-09-17T02:37:29Z")
Relations are case sensitive. I believe that any email entry via user sign in or possibly through an email component as well, will force lower case??? If you are typing in a list manually and using split text to split them apart for use in a relation, then they aren’t necessarily recognized as email values. What you could do is create a column in your sheet with an arrayformula to force lowercase `=LOWER(email, email2, email3)`. Then use then split the value of that column and use it for your relations.
---
### Author:  [@McJagger](https://community.glideapps.com/u/McJagger)
#### Post date: [September 17, 2020, 1:58pm UTC](https://community.glideapps.com/t/if-a-cap-in-the-email-not-matching/15868/3 "2020-09-17T13:58:53Z")
Yeah, the sign-in forces it as you mention, but a user in another place is able to manually enter with cap (copy & paste). Wasn’t using a split, these were emails entered by another user (essentially “add to my project”) and they would copy and paste from a list they have and when they put it in it wasn’t reading as an email. **But as I typed that last part it made me realize I hadn’t made the entry an email entry, I made it text entry**. Rookie mistake. Thanks for talking it out! Your suggestion will help me fix the ones already in, so super thanks!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 17, 2020, 10:26pm UTC](https://community.glideapps.com/t/if-a-cap-in-the-email-not-matching/15868/4 "2020-09-17T22:26:01Z")
The last time we had a bug report like this it was because of the wrong type of entry component as well, so hopefully there would be some kind of a warning when people use text entry on an email column.
---
### Author:  [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [September 28, 2020, 10:13pm UTC](https://community.glideapps.com/t/if-a-cap-in-the-email-not-matching/15868/5 "2020-09-28T22:13:00Z")
This issue is also applicable to special columns in forms – they force lower case which obviously breaks relations. Impossible to control letter case everywhere in an app on top of how users enter it.
---
### Author:  [@merkle](https://community.glideapps.com/u/merkle)
#### Post date: [April 8, 2021, 12:03am UTC](https://community.glideapps.com/t/if-a-cap-in-the-email-not-matching/15868/6 "2021-04-08T00:03:52Z")
My email entry fields don’t seem to be forcing to lower case? Can somebody confirm that they are supposed to? @Mark?
It would be a SUPER helpful feature or option, as users entering or copying pasting new emails into my app when adding contacts is causing relations to drop off and all kinds of chaos…
---
### Author:  [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [April 8, 2021, 12:19am UTC](https://community.glideapps.com/t/if-a-cap-in-the-email-not-matching/15868/7 "2021-04-08T00:19:58Z")
Yes, email entries are currently case-sensitive, but I see the point of wanting the option to force lowercase.
---
### Author:  [@merkle](https://community.glideapps.com/u/merkle)
#### Post date: [April 8, 2021, 12:22am UTC](https://community.glideapps.com/t/if-a-cap-in-the-email-not-matching/15868/8 "2021-04-08T00:22:55Z")
thanks for confirming @Mark. I’ll have to write a hint that tells people to ensure emails are lowercase (not ideal but will do for now).
Especially if users are manually importing contacts into the app - bound to have some random caps in there that throw things out when later trying to relate to user emails. Could easily be a toggle option on the email form field? ‘Force lower case’?
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [April 29, 2022, 10:29pm UTC](https://community.glideapps.com/t/if-a-cap-in-the-email-not-matching/15868/9 "2022-04-29T22:29:22Z")
Closing due to inactivity. This topic will be deleted in a few weeks if there are no more comments.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [April 29, 2022, 10:29pm UTC](https://community.glideapps.com/t/if-a-cap-in-the-email-not-matching/15868/10 "2022-04-29T22:29:22Z")
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [May 29, 2022, 10:29pm UTC](https://community.glideapps.com/t/if-a-cap-in-the-email-not-matching/15868/11 "2022-05-29T22:29:40Z")
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [May 29, 2022, 10:29pm UTC](https://community.glideapps.com/t/if-a-cap-in-the-email-not-matching/15868/12 "2022-05-29T22:29:40Z")