Capitalization in email results in not matching for relationship

[Rosewebstudio]

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

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?

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…