Case Sensitivity w/ Email Lookups

[Rosewebstudio]

Hi @a.manda

I remember this topic being discussed before.

If it helps

Any way to prevent case-sensitive matches?

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…