I’m not 100% sure if this qualifies as a bug. Apologies if not.
My solution for a specific customer comprises a Client app and an Admin app talking to the same Google Sheet.
The Client app uses email whitelist authentication in order to ensure that only certain clients can use it. My Admin app allows the customer to add clients including their email address. In this way the customer retains control of who can use the app and (most importantly) doesn’t need access to the Google Sheet.
It turns out that my customer has added some clients with mixed case for their email. This is matching fine when they try to login so no issue there. However, it screws up any relationships within the app that use currently authenticated user. This seems like a bug to me since email should never be matched using case sensitivity, whereas in this scenario it most definitely is.
To make matters worse, there doesn’t appear to be any mechanism whereby I can ensure that my customer only uses lowercase or even to convert their input automatically to lowercase.
I propose that the case insensitivity should be removed for “authenticated user email” relationship matching or perhaps email input fields should automatically force to lowercase?
Hopefully I’ver explained this clearly and thanks for any assistance that can be offered.