# Case Sensitivity w/ Email Lookups **URL:** \ **Category:** Ask for Help\ **Created:** [December 18, 2020, 9:00pm UTC](https://community.glideapps.com/t/case-sensitivity-w-email-lookups/20053 "2020-12-18T21:00:19Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![a.manda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a.manda/32/32645_2.png) [@a.manda](https://community.glideapps.com/u/a.manda)\ **Post date:** [December 18, 2020, 9:00pm UTC](https://community.glideapps.com/t/case-sensitivity-w-email-lookups/20053/1 "2020-12-18T21:00:20Z")
Hi All, I brought this up in an unrelated thread and am switching to a new topic for clarity and proper Discourse habits (and more input! šŸ•µšŸ»ā€ā™€ļø) I have an email column marked as row owner in my Glide-owned **User Data sheet**. This is the email address the user logged in with. Also in the **User Data sheet** I have an email relation column which connects the **User Data sheet** to a **Member Directory sheet** where members have input their own email address, sometimes using mixed case. I then have a look-up column in the **User Data sheet** which specifically looks up the email address that the member input into the **Member Directory sheet**. All of this is so the app knows when a logged in user is a directory member or not. (My users consist of directory members as well as outsiders, so lots of visibility settings happening) I discovered an issue as soon as I shared the app with a few test users where Glide does not match mixed case email addresses in the lookup column - meaning a member who used a capital ā€œDā€ in her address was not being recognized as a member. I did some research on the forums and it seems that Glideā€™s relations _are_ case-sensitive? I ā€œfixedā€ my issue by creating a hidden column in my **Member Directory sheet** with a formula that converts all emails to lowercase. I then changed my Glide sheet to reference that column instead. My question is - was this the right solution? Is there a better solution? Iā€™ve noticed since this fix that my app is slower to load, though this could be the result of other concurrent changes šŸ¤” Also - is Glideā€™s case sensitivity here expected behavior? Or would it be considered a bug? I am guessing that columns specifically marked as ā€œemail addressā€ are not case-sensitive, but there is no way to mark a look-up column as containing an email address - correct? (I donā€™t want to ask my users to modify their behavior when inputting their emails into the shared Google sheet) Appreciate any thoughts here, thanks always! . . . . Prior bit of discussion on this topic here if interested (itā€™s @ the end of an unrelated thread šŸ˜¬): > [@500 Row Limit - What Counts?](https://community.glideapps.com/t/500-row-limit-what-counts/19702/23): > > Sorry to go off topic, but do all formulas in Google sheets cause a delay, or only ones like this Vlookup? I ask because I put a column into my Google sheet thatā€™s simply a lowercase conversion formula, and ever since then my app takes five full seconds to load instead of the immediate load it had before. (I have a relation within Glide to this lowercase column too) I had made several changes at once in addition to this one before the delay occurred so Iā€™ve been avoiding the nightmare of tryingā€¦ ---
**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:** [December 18, 2020, 9:12pm UTC](https://community.glideapps.com/t/case-sensitivity-w-email-lookups/20053/2 "2020-12-18T21:12:23Z")
Hi @a.manda I remember this topic being discussed before. If it helps ā¬‡ > [@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ā€¦ ---
**Author:** ![a.manda](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a.manda/32/32645_2.png) [@a.manda](https://community.glideapps.com/u/a.manda)\ **Post date:** [December 18, 2020, 9:35pm UTC](https://community.glideapps.com/t/case-sensitivity-w-email-lookups/20053/3 "2020-12-18T21:35:22Z")
This is super helpful! (And somehow I missed it in my research, thank you) Looks like this IS the current solution then, and hopefully itā€™s not the cause of my sudden slow-load. Would be cool if Glide added a ā€œCase sensitive?ā€ checkbox to their Lookup columns! ---
**Author:** ![Cisco\_Muratalla](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cisco_muratalla/32/12358_2.png) [@Cisco\_Muratalla](https://community.glideapps.com/u/Cisco_Muratalla)\ **Post date:** [December 18, 2020, 10:04pm UTC](https://community.glideapps.com/t/case-sensitivity-w-email-lookups/20053/4 "2020-12-18T22:04:38Z")
I experienced the same with user emails and case sensitivity, agree itā€™d be useful to have a native way to handle this use case. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 19, 2020, 4:36am UTC](https://community.glideapps.com/t/case-sensitivity-w-email-lookups/20053/5 "2020-12-19T04:36:59Z")
I have had to have sheets just force everything with a email to lower case