# Capitalization in email results in not matching for relationship

**URL:** <https://community.glideapps.com/t/capitalization-in-email-results-in-not-matching-for-relationship/30118>\
**Category:** Ask for Help\
**Created:** [August 6, 2021, 6:04pm UTC](https://community.glideapps.com/t/capitalization-in-email-results-in-not-matching-for-relationship/30118 "2021-08-06T18:04:34Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [August 6, 2021, 7:09pm UTC](https://community.glideapps.com/t/capitalization-in-email-results-in-not-matching-for-relationship/30118/2 "2021-08-06T19:09:21Z")

</div>

Hi 👋

If your using a google sheet (as opposed to a glide table) these solutions may help you.

> [@If a CAP in the email, not matching](https://community.glideapps.com/t/if-a-cap-in-the-email-not-matching/15868):
>
> 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…

> [@Any way to prevent case-sensitive matches?](https://community.glideapps.com/t/any-way-to-prevent-case-sensitive-matches/5315):
>
> I use the “Unique” function quite often to get a list of users from the App:Login sheet. The issue I’ve been having is that the Unique function is “too unique” haha. Sometimes a user will log in more than once and sometimes users log in and the first letter of their email address is capitalized. This shows as a unique value to my other sheets. I’m curious what others do to prevent this behaviour. I can’t ensure that users always log in with the same case in their email addresses, so I’m looking…

---

_[View the full topic](https://community.glideapps.com/t/capitalization-in-email-results-in-not-matching-for-relationship/30118)._
